-
Adding Tablespaces
I need to add tablespaces to a database. Can I run the sql that creates them logged in as SYSTEM? Do I have to invoke svrmgrl and connect internal? Thanks.
-
You can either add a tablespace as system user or any user with DBA previlege. You can run it thru svrmgrl or thru sqlplus or any other client tool like oem or toad.
-
run the "alter tablespace add datafile '...." as system
-
run the "alter tablespace add datafile '...." as system
How does that create a tablespace?
-
SQL> alter tablespace newone add datafile 'c:\temp' size 100k;
alter tablespace newone add datafile 'c:\temp' size 100k
*
ERROR at line 1:
ORA-00959: tablespace 'NEWONE' does not exist
-
you right I'm confuse the command.
the right commend is:
SQL>create tablespace xxx datafile '.....' size XXXM;
thanks
-
also need more than that
like extent management local? uniform extents? autoextend (if you like it)
-
Originally posted by mauric
you right I'm confuse the command.
I learn something new here almost every day. Don't be afraid to post answers or questions. If you're wrong, there are plenty of people who will point it out for you. And a lot of times, there is more than one "right" answer.
-
There is an on-line 9i documentation. You can refer to it. http://tahiti.oracle.com/pls/db92/db92.homepage
-
Example in 9i
CREATE TABLESPACE "TOOLS" DATAFILE 'Y:\ORACLE2\ORADATA\TOOLS01.DBF' SIZE 1000M
AUTOEXTEND ON
NEXT 320K
MAXSIZE 32767M
BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 1m
SEGMENT SPACE MANAGEMENT AUTO ;
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
|