Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Unanswered: Oracle Export and Import - 8i

    I have Oracle-8i database. If I make a dump file with export command option full=y, can I do:
    1. Import the data for a 'particular user' from the export dump file by using fromuser=xxx touser=xxx into the existing database ( I delete the user cascade before )? Is there a way to import multiple users at the same time?
    2. How can I use the export dump file and import data into a new database which creates all the stuff from the dump file? I suppose it expects to have users before hand. Can I avoid this issue?


  2. #2
    Join Date
    Jul 2003
    this is for 9i, but you can look up 8i as well.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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