copying data from one tablespace to other
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.
CREATE TABLE B.FOOBAR
AS SELECT * FROM A.FOOBAR;
Click Here to Expand Forum to Full Width