DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Exp-0007

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Give detailed version of your Oracle. like 8.1.7.2
    -nagarjuna

  3. #3
    Join Date
    Sep 2002
    Posts
    376
    hi nagarjuna,
    i am using 8.1.6

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    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."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Sep 2002
    Posts
    376
    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.

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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's Blog  Get Firefox!

  7. #7
    Join Date
    Sep 2002
    Posts
    376
    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.

  8. #8
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width