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

Thread: export/import problem ..

  1. #1
    Join Date
    Aug 2001
    Posts
    267
    WE have a database running on 7.3.4 . When I am trying to export or import the schema I am getting the error . Export views are not created in the database .contact DBA . Do we have to run any .sql files on that databse ? . Or any advise ..Thanks in advance ..


    Raghu
    Raghu

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    It sounds like you are either running a different version of export than your target database, or the export views were never created. To create the export views, run ?/rdbms/admin/catexp.sql from svrmgrl as internal.
    Jeff Hunter

  3. #3
    Join Date
    Aug 2001
    Posts
    267
    Yes Jeff I am running 8.1.7 client .. I am using same client for 8.0 or higher . But this is the first time I am using 8.1.7 vs 7.3.4 database .. Let me try same client ..

    Raghu
    Raghu

  4. #4
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    You have to use the 7.3.4 exp program to do the export.

    Take a look at note 132901.1 on metalink : Compatibility Matrix for Export & Import between different Oracle Versions

    Regards
    Gert


  5. #5
    Join Date
    Aug 2001
    Posts
    267
    Please give the full meta link path .. Thanks in advance ..

    Raghu
    Raghu

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    in metalink's advanced search there is a search condition DOC_ID just put 132901.1 and search

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