How will the datafile expand when it is unlimited?
I issued a command
ALTER TABLESPACE "USERS" ADD DATAFILE 'E:\DATABASE\USERS02.DBF' SIZE 31G AUTOEXTEND ON NEXT 512K MAXSIZE UNLIMITED,
what would happened if the file reaches 31g needs to extend,will it do it up to 32 g or will it go more till there is no room on the disk?
ALTER TABLESPACE "USERS" ADD DATAFILE 'E:\DATABASE\USERS02.DBF' SIZE 31G AUTOEXTEND ON NEXT 512K MAXSIZE UNLIMITED,
what would happened if the file reaches 31g needs to extend,will it do it up to 32 g or will it go more till there is no room on the disk?
0