| Transportable tablespace error [message #127333] |
Mon, 11 July 2005 05:16  |
deepa_balu
Messages: 74
Registered: March 2005
|
Member |
|
|
Hi,
i am trying to use the transport tablespace option in Exp and Imp.
I did the following:
1.create tablespace testtran datafile 'testtran.dbf' size 2M autoextend on;
2.create user sri identified by sri default tablespace testtran;
connect as user sri
3.create table sri1 as select * from all_objects;
connect as system and
4.alter tablespace testtran read only;
exp userid=\"sys/change_on_install as sysdba\ file=testtran.dmp transport_tablespace=y tablespaces=testtran
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
For tablespace TESTTRAN ...
. exporting cluster definitions
. exporting table definitions
. . exporting table SRI1
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
. exporting referential integrity constraints
. exporting triggers
. end transportable tablespace metadata export
Why am i getting this table does not exist error.
i checked this also
SQL> select tablespace_name from dba_tables where table_name='SRI1';
TABLESPACE_NAME
------------------------------
TESTTRAN
Bcos of this when doing import tables are not getting created.But tablespace gets plugged in
[Updated on: Mon, 11 July 2005 05:19] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
