-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|