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

Thread: catexp.sql

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Posts
    151
    Hi all,

    How can I check to see if my db ever run catexp.sql berfore?
    any view/table I can querry to verify it?
    Do I have to run it again even previous dba might have run it before? (she might not have run it??)
    Elin@trend

  2. #2
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Try to export or import a small table. If it bombs out with an error pointing to the absence of export/import views, then you will need to run it. On the other hand, there would be no harm if you ran it again even though u're not sure.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by elintrend
    Hi all,

    How can I check to see if my db ever run catexp.sql berfore?
    any view/table I can querry to verify it?
    Check the catexp.sql script itself. It contains a bunch of "CREATE OR REPLACE VIEW..." statements. Check for the existance of any of those views in your database to find out if the catexp.sql was ever run before.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Not sure about old version. Oracle latest versions(8i) catalog.sql include catexp.sql script.
    Reddy,Sam

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