Import to defferent USER with defferent TABLESPACE?
I need to import data from user(MCA) to another user(TEST).The default tablespace of user(MCA) is MCA_TS and TEST_TS is the default table space for user(TEST) Both are user/tbl space residing within one database.
SQL> CREATE USER TEST IDENTIFIED BY TEST
DEFAULT TABLESPACE TEST_TS TEMPORARY TABLESPACE TEST_TEMP
QUOTA UNLIMITED ON TEST_TS;
/
SQL> GRANT CONNECT,CREATE TABLE,CREATE TRIGGER,CREATE PROCEDURE,CREATE VIEW,CREATE SEQUENCE TO TEST;
/
IMP SYSTEM/PWD FROMUSER=MCA TOUSER=TEST FILE=XXXX.DMP
when i try to imp....error showing....