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;