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

Thread: copying data from one tablespace to other

  1. #1
    Join Date
    Jan 2003
    Posts
    38

    copying data from one tablespace to other

    Hello all,

    I am not aware of dba stuff but just wanted to get one thing clarified ...

    Is it possible in oracle to copy data ( tables ) from one tablespace to another without using export/import ?

    eg. User A - default tablespace A - table A
    User B - default tablespace B - no table

    Is it possible to create a table B in tablespace B with user B which is an exact replica of table A which resides in tablespace A and owned by user A

    Can this be done from sql ?

    Any help is highly appreciated.

    Thanks
    K

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sure

    CREATE TABLE B.FOOBAR
    TABLESPACE fooB
    AS SELECT * FROM A.FOOBAR;
    Jeff Hunter

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