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

Thread: import/export question

  1. #1
    Join Date
    Oct 2000
    Posts
    57
    I have a question regarding import/export. I have set up new DB ready for an import. I will need to REFRESH all the data in two or three weeks time. Do I just do another export then import, or do I have to completely REBUILD the DB???

    Thanks in advance.

    Paul

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    Yes, you can export&import only, BUT in Oracle databases you have ** MANY ** other options to refresh data between 2 databases. To name a few : replication of data, send/applying the redo logs, manual snapshots, db links, transportable tablespaces (very good : you only copy the data files to the other database !) , and others.
    Depending of your version, you can have all or only a few of this options - check your documentation, specially the Server Admin Guide manual.

    []s
    Chiappa

  3. #3
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    Hi!
    You can tak eincremental Exports. type exp help=y to see how to take incremental export. And then import them in the new db.
    BTW in two or three weeks time will there be any major database management related activities like tablespace creation etc. If yes it is advisable to recreate db.
    Have to thought of useing transportable tablespaces?
    There Nothing You cannot Do, The problem is HOW.

  4. #4
    Join Date
    Oct 2000
    Posts
    57
    It looks like the DESTROY=Y option overwrites any data files previously set up. Thanks.

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