Unanswered: Error when transporting 22.214.171.124 tablespaces
I have two 126.96.36.199 tablespaces where I'm trying transport a tablespace from one 2000 server to another 2000 server. The import immediately fails and kills the Oracle service. On the source database I execute (after putting the users tablespace in read only mode)
exp transport_tablespace=y tablespace=users contraints=n grants=n file=export_tbsp.dmp triggers=n
I then copy the export dump file and the datafiles that make up the tablespace to the target server. I create the user gcs with the following command:
create user gcs identified by pwd
temporary tablespace temp;
I did not define a default tablespace (which would be users and doesn't exist yet)
I run the imp command
imp transport_tablespace=y file=export_tbsp.dmp datafiles=('pathto datafile') tts_owner=gcs fromuser=gcs touser=gcs
I connect / as sysdba
Connected to: Oracle9i Enterprise Edition Release 188.8.131.52.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 184.108.40.206.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
About to import transportable tablespace(s) metadata...
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
IMP-00017: following statement failed with ORACLE error 3113:
"BEGIN sys.dbms_plugts.beginImport ('220.127.116.11.0',31,'2000',NULL,'NULL',3104"
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully
The 3113 means the service has been killed.
Any ideas on what my problem is?