|
-
OK. I added a datafile using command:
'alter tablespace /tablespace name/ add datafile /datafile name/ size 50m;
For some reason through GUI tool it says my datafile size is unlimited. ??? Is it right?
How do I look it up through sqlplus?
Also, I would like to alter it using: alter database datafile /datafile name/ autoextend off next 50m maxsize 500m and get ORA-00900: invalid SQL statement
When I set autoextend on it works fine.
What am I missing here?
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
|
Reply With Quote