Oracle Database Discussions

Hi,

I have taken export in schema level from DEV region (11g / OS : AIX) :

exp file=/tmp/sms_04112011.dmp log=/tmp/sms_04112011.log direct=y feedback=100000 grants=no indexes=no constraints=no owner=SMS

while importing in TEST region (11g / OS : AIX) getting below errors :

imp file=/tmp/sms_04112011.dmp log=/tmp/sms_04112011_imp.dmp feedback=100000 buffer=100000 fromuser=SMS touser=SMS ignore=y

its looking for same tablespace name (belongs to DEV) in TEST region.

IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 205
ORA-00959: tablespace 'SMS_DEV_DATA' does not exist
IMP-00017: following statement failed with ORACLE error 604:

ie., tablespace name in DEV : SMS_DEV_DATA , tablespace name in TEST : SMS_TEST_DATA.

while importing in TEST, its searching for SMS_DEV_DATA. data is not importing to tablespace name : SMS_TEST_DATA where tables are not already created & having few records.

Thx
Gowin.