-
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
-
Give detailed version of your Oracle. like 8.1.7.2
-nagarjuna
-
hi nagarjuna,
i am using 8.1.6
-
Re: Exp-0007
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
Amar
"There is a difference between knowing the path and walking the path."
-
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.
-
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
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
Amar
"There is a difference between knowing the path and walking the path."
-
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.
-
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.
Amar
"There is a difference between knowing the path and walking the path."
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|