copying data from one tablespace to other

[marist89]

Sure

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