DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Adding Tablespaces

  1. #1
    Join Date
    Jan 2001
    Posts
    138

    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.

  2. #2
    Join Date
    Nov 2002
    Posts
    170
    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.

  3. #3
    Join Date
    Jan 2003
    Posts
    6
    run the "alter tablespace add datafile '...." as system

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    run the "alter tablespace add datafile '...." as system
    How does that create a tablespace?

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    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

  6. #6
    Join Date
    Jan 2003
    Posts
    6
    you right I'm confuse the command.

    the right commend is:
    SQL>create tablespace xxx datafile '.....' size XXXM;

    thanks

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    also need more than that
    like extent management local? uniform extents? autoextend (if you like it)

  8. #8
    Join Date
    May 2002
    Posts
    2,645
    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.

  9. #9
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    There is an on-line 9i documentation. You can refer to it. http://tahiti.oracle.com/pls/db92/db92.homepage

  10. #10
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    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
  •  


Click Here to Expand Forum to Full Width