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

Thread: scheduling

  1. #1
    Join Date
    Apr 2003
    Location
    india
    Posts
    13

    Question scheduling

    i am having netware server 5.1 with oracle 8 . daily i am exporting one user`s database into some .dmp file by using enterprise manager and whenever i need i am importing that file . are there any scheduling options in oracle 8 enterprise manager for netware . one more thing i have to clarify is can we export the database of an oracle 8 server`s user by using oracle 8i client . plz help me in these issues
    thanks in advance

  2. #2
    Join Date
    May 2001
    Posts
    736
    It is not possible to take export from higher version to lower version except in 9i.

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by akhadar
    It is not possible to take export from higher version to lower version except in 9i.
    Thats not what was being asked. This question is "can i use 8i export utility to export from an 8.0 database.".

    I don't think it is possible, although you CAN create an Oracle 8.0 export file from an 8i database.

    You could just try it though -- Oracle will soon tell you if you can't.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by slimdave
    I don't think it is possible, although you CAN create an Oracle 8.0 export file from an 8i database.
    yes it may be possible if you run Orale8i catexp on Oracle8.0 database, that will create the export views required by the oracle8i exp utility to do an export from oracle8.0 database.

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Apr 2003
    Location
    india
    Posts
    13
    Originally posted by adewri
    yes it may be possible if you run Orale8i catexp on Oracle8.0 database, that will create the export views required by the oracle8i exp utility to do an export from oracle8.0 database.

    HTH
    where did i get that catexp and how to use it ??
    akhir dil hi hindustani

  6. #6
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by dinkar
    where did i get that catexp and how to use it ??
    In the place/box where you have installed Oracle 8i client, see in $ORACLE_HOME/RDBMS/ADMIN.

    The script has instructions about how to run it.

    HTH.

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    dinkar, why don't you just use the v8 client to export from the v8 database? Where does this fascination with 8i export come from?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  8. #8
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by dinkar
    where did i get that catexp and how to use it ??
    If you don't know where it is then this solution is not for you.

    My answer was to state one of the possibilities. So if you do not have much experience (and you don't have, your question says all) then don't do it, cause running Oracle8i catexp will overwrite your existing oracle8.0 export views.

    First try what is in hand, if it does not work, go to Oracle support and even if then it doesn't work (which is less likely) then only go for other possibilities.

    Go with what slimdave has suggested.

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  9. #9
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    caan you find a reference in the documentation to executing the 8i catexp on 8?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  10. #10
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by slimdave
    caan you find a reference in the documentation to executing the 8i catexp on 8?
    This one is not documented in Oracle Documentations but is a solution that works.

    Ok here is reference pointer.
    http://metalink.oracle.com/metalink/...&p_id=158845.1

    HTH
    Last edited by adewri; 04-23-2003 at 10:25 AM.
    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