Database Administration (MOSC)

MOSC Banner

How will the datafile expand when it is unlimited?

edited Jan 19, 2010 10:36PM in Database Administration (MOSC) 13 commentsAnswered
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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center