| EXP-00011... [message #458161] |
Thu, 27 May 2010 11:18  |
sahadba
Messages: 59
Registered: September 2009
Location: Pune
|
Member |
|
|
Hi,
I am working on a task of Export Import from Production to Development. After the import when i checked for the number of tables in the target database & i found the number was less. On checking the logs i did not find any relevant errors.
Commands Used
Export:-
exp owner=Q04_IT11_GLORIA_MAINTENANCE_DB file=exp.dmp log=exp.log consistent=y
Import:-
imp fromuser='Q04_IT11_GLORIA_MAINTENANCE_DB'
touser='IT11_GLORIA_MAINTENANCE_DB_11G' file=exp.dmp log=imp.log
I queried the Databases of both Source and Target and found that certain tables with names like DR$BG_TEXT_IDX$I were missing, In all 24 such tables are there, I tried to describe and select those tables which gave the below error
SQL> select * from DR$BG_TEXT_IDX$I;
select * from DR$BG_TEXT_IDX$I
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> desc DR$BG_TEXT_IDX$I
ERROR:
ORA-04043: object DR$BG_TEXT_IDX$I does not exist
I queried the type of these objects as below
SQL> select object_type from dba_objects where owner ='Q04_IT11_GLORIA_MAINTENANCE_DB' and object_name='DR$BG_TEXT_IDX$I';
OBJECT_TYPE
-------------------
TABLE
I tried to individually export those tables which gave me an error: -
oracle@lxx0093:/prd/dvp/ora/exp/ > exp file=testing.dmp log=testing.log tables=DR$BG_TEXT_IDX$I consistent=y
Export: Release 10.2.0.4.0 - Production on Thu May 27 17:46:25 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Username: system
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
Export done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
EXP-00011: SYSTEM.DR does not exist
Export terminated successfully with warnings.
Are these PL/SQL Tables..?
Please help me understand why these tables cannot be exported or is there a way to do so.
Thank You..
[Updated on: Thu, 27 May 2010 11:22] Report message to a moderator |
|
|
|
|
|
|
|
| Re: EXP-00011... [message #458255 is a reply to message #458211] |
Fri, 28 May 2010 04:13  |
sahadba
Messages: 59
Registered: September 2009
Location: Pune
|
Member |
|
|
Thanks Guys,
But it's still not working..
oracle@lxx0093:/prd/dvp/ora/exp/ > exp file=testing.dmp log=testing.log tables=Q04_IT11_GLORIA_MAINTENANCE_DB.DR\$BG_TEXT_IDX\$I consistent=y
Export: Release 10.2.0.4.0 - Production on Fri May 28 11:10:35 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Username: system
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
Export done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
Current user changed to Q04_IT11_GLORIA_MAINTENANCE_DB
EXP-00011: Q04_IT11_GLORIA_MAINTENANCE_DB.DR$BG_TEXT_IDX$I does not exist
Export terminated successfully with warnings.
Why is it not able to Identify the table??
select object_name, object_type
from dba_objects
where owner='Q04_IT11_GLORIA_MAINTENANCE_DB'
and object_name like '%$%'
and object_type='TABLE';
OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------
DR$BG_TEXT_IDX$I TABLE
DR$BG_TEXT_IDX$K TABLE
DR$BG_TEXT_IDX$N TABLE
DR$BG_TEXT_IDX$R TABLE
DR$CO_TEXT_IDX$I TABLE
DR$CO_TEXT_IDX$K TABLE
DR$CO_TEXT_IDX$N TABLE
DR$CO_TEXT_IDX$R TABLE
DR$CS_TEXT_IDX$I TABLE
DR$CS_TEXT_IDX$K TABLE
DR$CS_TEXT_IDX$N TABLE
OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------
DR$CS_TEXT_IDX$R TABLE
DR$DS_TEXT_IDX$I TABLE
DR$DS_TEXT_IDX$K TABLE
DR$DS_TEXT_IDX$N TABLE
DR$DS_TEXT_IDX$R TABLE
DR$RQ_TEXT_IDX$I TABLE
DR$RQ_TEXT_IDX$K TABLE
DR$RQ_TEXT_IDX$N TABLE
DR$RQ_TEXT_IDX$R TABLE
DR$TS_TEXT_IDX$I TABLE
DR$TS_TEXT_IDX$K TABLE
OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------
DR$TS_TEXT_IDX$N TABLE
DR$TS_TEXT_IDX$R TABLE
24 rows selected.
[Updated on: Fri, 28 May 2010 04:22] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
