Database Utilities (MOSC)

MOSC Banner

Import to defferent USER with defferent TABLESPACE?

edited Dec 23, 2011 9:55AM in Database Utilities (MOSC) 9 comments
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....

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center