Results 1 to 2 of 2

Thread: export/import

  1. #1
    Join Date
    Jun 2002
    Location
    kl
    Posts
    3

    Unanswered: export/import

    Hiii,friends i have 40 tables in oracle8i db with lacks of data each table,
    Now we would like to move 8idb into 9idb.
    I was created 9i db.
    Which method is best to move the data into new db.
    copy or export/imp or advise me any other method.
    thanks
    kavitha

  2. #2
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    Just use schema export from 8i and import it to 9i, or if those 40 tables reside in multiple schemas, then export those schemas.

    That would be the fastest way. (exp userid= file= log= owner= ...)

    Hope that helps,

    clio_usa
    OCP DBA
    visit our web site: Here
    .
    .
    .

Posting Permissions

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