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

Thread: tablespace

  1. 05-24-2002, 12:53 AM #1
    kavithared
    kavithared is offline Member
    Join Date
    May 2002
    Posts
    232
    it is silly question
    hiii friends i was created tables in systemtables space and some other one is xyz.
    But i like to create in xyz only,shall i copy the tables from system tablespace to xyz.
    if ok?
    how to copy.?
    kavitha
    kavitha
    Reply With Quote Reply With Quote
  2. 05-24-2002, 01:04 AM #2
    sanjana
    sanjana is offline Junior Member
    Join Date
    May 2002
    Posts
    6
    Hi,

    Use EXP/IMP utility.

    Bye.
    Reply With Quote Reply With Quote
  3. 05-24-2002, 01:07 AM #3
    gnagesh
    gnagesh is offline Senior Member
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    You can You ALTER TABLE MOVE TABLESPACE command.

    Nagesh
    Reply With Quote Reply With Quote
  4. 05-24-2002, 01:08 AM #4
    gnagesh
    gnagesh is offline Senior Member
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Sorry,

    Ignore the previous one.

    You can use ALTER TABLE MOVE TABLESPACE command.

    Nagesh
    Reply With Quote Reply With Quote
  5. 05-24-2002, 01:10 AM #5
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    If you are using 8i or above...

    ALTER TABLE table_name MOVE TABLESPACE ts_name;

    Sanjay
    Reply With Quote Reply With Quote
  6. 05-24-2002, 05:17 AM #6
    Sureshy's Avatar
    Sureshy
    Sureshy is offline Advisor
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    remeber. will not work with LONG RAW datatypes
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.
    Reply With Quote Reply With Quote
  7. 05-24-2002, 11:34 AM #7
    mrvajrala
    mrvajrala is offline Senior Member
    Join Date
    Feb 2001
    Posts
    290
    One more important thing is check if any user is having
    DEFAULT_TABLESPACE as SYSTEM , if so you may wish to alter the USER to another tablespace. Have a look at TEMPORARY_TABLESPACE too
    Madhu Reddy
    xdollor@yahoo.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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