Results 1 to 2 of 2

Thread: Data migration

  1. #1
    Join Date
    Aug 2003

    Unanswered: Data migration

    Hello everybody,
    anybody knows if it's possible to make an export/import working ONLY on data?
    This is the matter: i have a db on Oracle server 7.3 and i have to build and identical instance on an Oracle server 8.1.7, just modifying some storage parameters (initial, extents and so on).
    Doing a complete exp/imp i can't, after the import, modify those parameters, can i?
    Then i was thinking about building the structure of my instance (with modified parameters) through an SQL script and migrate ONLY the data (a lot of data...). Notice that tables are built with the same number of fileds, then data migration shouldn't be a problem.
    How can i do an exp/imp only on data (without any structure)? Any other hints?

    Thank you very much,


    p.s. i'm in a very big hurry.... thankx again!!!

  2. #2
    Join Date
    Oct 2003

    First imp data in the new oracle instance with old structure then run the script to modify the parameters.


Posting Permissions

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