Any tools for Viewing Export File Contents ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Any tools for Viewing Export File Contents ?

  1. #1
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    Hi All,

    Are there any external tools available in the market so that we can view the contents of an Export file. Just the structure, the users, tables etc.

    Thanks
    Sridhar

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    you can import to an indexfile.

    imp help=y

    [Edited by Sureshy on 05-30-2002 at 11:48 AM]
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi

    If you just wanna see the structure why dont use the export utility with ROWS=N option.

    unless i did not understand your question properly.the above solution should solve your problem.

    If you are on 9i then you can esaily get the DDL out of the data dictionary with DBMS_DDL package.

    regards
    Hrishy

  4. #4
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    Hrishy,

    I was looking at something without actually doing an import.

    Using the option show=y, we can generate a file with all the
    ddl. But sometimes this file could be big. I was looking at something that say reads this file and shows the structure in a gui.

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