Home » RDBMS Server » Server Utilities » EXP-00011... (Oracle 10g R2, Linux Redhat 5)
EXP-00011... [message #458161] Thu, 27 May 2010 11:18 Go to next message
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 #458162 is a reply to message #458161] Thu, 27 May 2010 11:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please help me understand why these tables cannot be exported or is there a way to do so.

DOLLAR SIGN character is a metacharacter to OS shell & need to be escaped

exp file=testing.dmp log=testing.log tables=DR\$BG_TEXT_IDX\$I consistent=y
Re: EXP-00011... [message #458211 is a reply to message #458162] Thu, 27 May 2010 23:06 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Also specify TABLES=OWNER.TABLE_NAME (Schema name missing in your export script)

Babu
Re: EXP-00011... [message #458255 is a reply to message #458211] Fri, 28 May 2010 04:13 Go to previous messageGo to next message
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

Re: EXP-00011... [message #458275 is a reply to message #458255] Fri, 28 May 2010 06:46 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Are you trying in same database Or different database?

Re: EXP-00011... [message #458276 is a reply to message #458275] Fri, 28 May 2010 06:53 Go to previous messageGo to next message
sahadba
Messages: 59
Registered: September 2009
Location: Pune
Member

Thanks for the response Babu..

Different databases..
Exporting from production and importing it to Development.
I am getting errors in export, as i showed in my previous post...
Re: EXP-00011... [message #458303 is a reply to message #458276] Fri, 28 May 2010 09:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I suspect these are context index tables which will be created when you use text indexing.
These are not regular tables.
Re: EXP-00011... [message #458304 is a reply to message #458276] Fri, 28 May 2010 09:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Here you go
http://www.oracle.com/technology/products/text/x/samples/Exp_Imp/index.html
Quote:
The DR$ objects which make up the Text index in the user schema are also special for export and it will refuse to export them (EXP-00011 exception). This is only proper, since they'd be useless anywhere but in the environment where they were created (due to ROWID references).
Re: EXP-00011... [message #458351 is a reply to message #458304] Fri, 28 May 2010 14:18 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

I missed. Thanks Mahesh.

Babu
Previous Topic: External Table
Next Topic: How to re-import a 9i dump file to 10g
Goto Forum:
  


Current Time: Fri Sep 17 08:02:19 CDT 2021