Exp-0007

Printable View

03-21-2003, 02:23 AM
bang_dba

Exp-0007

Hi,

When i am taking export i am getting this error.

EXP-00007: dictionary shows no columns for USERNAME.TABLENAME.
(Around some 5 tables in particular schema)

All these tables exist; but when EXPORT utility tries to export it throws this error.

But rest of the table in the user gets exporte fine and at the end it says export terminsted succesfully with warnigns.

I am using 8i on winNT and doing userlevel export.

Any ideas abt the same ?

Thanx
03-21-2003, 02:25 AM
nagarjuna

Give detailed version of your Oracle. like 8.1.7.2
03-21-2003, 02:29 AM
bang_dba

hi nagarjuna,
i am using 8.1.6
03-21-2003, 02:32 AM
adewri

Re: Exp-0007

Quote:

Originally posted by bang_dba
Hi,

When i am taking export i am getting this error.

EXP-00007: dictionary shows no columns for USERNAME.TABLENAME.
(Around some 5 tables in particular schema)

All these tables exist; but when EXPORT utility tries to export it throws this error.

But rest of the table in the user gets exporte fine and at the end it says export terminsted succesfully with warnigns.

I am using 8i on winNT and doing userlevel export.

Any ideas abt the same ?

Thanx

Just make sure you are using the proper owner to export those tables.

Check the owner from all_objects for those tables.

HTH
03-21-2003, 02:39 AM
bang_dba

Hi

Amar:

There are many tables in this schema. Ony few of them will throw this error and rest of them are getting exported fine.
03-21-2003, 02:47 AM
adewri

Did you check the owner for those tables ??

Do those table exist? are you able to querry those tables ?

This error was logged in as a bug under Oracle 7 version but your's is Oracle 8i.

Just verify those tables...

Can you show the owner,object_name,object_type of those tables from all_objects...

and try doing a select,insert on any of those tables...

From the Documents

Quote:

Cause: Export failed to gather column information from the data dictionary. The table may have been dropped.

Action: Retry the export and, if this error recurs, report it as an Export internal error to Oracle Support Services.

HTH
03-24-2003, 01:13 AM
bang_dba

Amar,

All the tables exist and i can do select from those tables as well.

Is there any PATCH availabe for the same. Where should i search for the patch.
Unfortunately we are not under oracle support.
03-24-2003, 01:24 AM
adewri

Quote:

Originally posted by bang_dba
Unfortunately we are not under oracle support.

Well, what can i say then...

Other options would be:

1. run catexp again.
2. then try user level export again.
3. try taking a full database export.
4. use spool to make a flat file and use sql loader to upload to the other database.
5. try using dblinks and then use "Create table as select * from username.table_name@dblink'

Its better you renew your Oracle Support.