Oracle certifications - REUSE without SIZE clause

Author

REUSE without SIZE clause

rohit1346

2002-04-09, 7:32 am

This is a question regarding the creation of data files..
If u use REUSE clause then u can omit the SIZE clause becuase the size of the existing file will be considered... but what happens in case a file does not exist and u use RESIZE option and omit the SIZE clause???

Ian_J

2002-04-09, 11:01 pm

at a guess you will get an error but I havent tested it. Try it on a database to find out.

stecal

2002-04-11, 9:55 am

REUSE clause tells Oracle to reuse an existing file. Without REUSE, you must specify a size. However, if you are on Oracle9i, Oracle will create some files using a default size (e.g., 100M for an undo tablespace, etc.).

Sponsored Links