-
I've got a datafile originally sized at 100M which has now autoextended to 130M. I have created a 2nd file in the tablespace (also of 100M and with AUTOEXTEND set to OFF).
how do I switch off the AUTOEXTEND on the 1st file?
I must be using the wrong syntax as I can't seem to do it.
-
It's Okay!
I was using ALTER TABLESPACE and not ALTER DATABASE!
My mistake. Sorry.
----------------------------
John
-
alter database datafile 'E:\ORACLE\ORADATA\NT817\INDX01.DBF' autoextend off;
Jeff Hunter
-
We must've posted at the same time.
Thanks anyway, Jeff.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|