Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Unanswered: Oracle 8 to Oracle 8

    Hi

    We currently need to export some data from Oracle (on Win 2000) and import to a new Oracle 8.1.7.4 (Win 2K) database.

    Can anyone advise on best procedure? Scripts, tools or other metods etc.

    Thanks

    Paul

  2. #2
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    export (exp) and import(imp). It doesn't get more basic then that. Read your "Utilities" documentation for specifics.

    HTH
    NOTE: Please disregard the label "Senior Member".

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    If it is a large amount of data that will need to be imported into the new database, Create a LARGE rollback segment in the new database. Take the smaller databases offline so that import will use the large rollback...

    Also, don't "pre"create the tables and indexes in the new database.

    HTH
    Gregg

  4. #4
    Join Date
    Jan 2004
    Location
    Venezuela
    Posts
    151

    Re: Oracle 8 to Oracle 8

    Originally posted by elegba21
    Hi

    We currently need to export some data from Oracle (on Win 2000) and import to a new Oracle 8.1.7.4 (Win 2K) database.

    Can anyone advise on best procedure? Scripts, tools or other metods etc.

    Thanks

    Paul
    What is the size of your database ?

    Documentaton for imp/exp utilities

    Utilities Contents / Search / Index / PDF
    http://download-east.oracle.com/docs...920/a96652.pdf
    Joel Pérez

  5. #5
    Join Date
    Jan 2004
    Posts
    7

    Oracle to Oracle

    The new database disk size should be about 60GB

  6. #6
    Join Date
    Jan 2004
    Location
    Venezuela
    Posts
    151

    Re: Oracle to Oracle

    I recommend you to test what is faster in your case, duplicate the database with exp/imp utilities or recreating the contronfile. Recreating the controlfile you have only to copy the datafiles and other files and apply some commands to duplicate the database.
    Joel Pérez

  7. #7
    Join Date
    Jan 2004
    Location
    Venezuela
    Posts
    151

    Re: Oracle to Oracle

    CREATE CONTROLFILE

    --------------------------------------------------------------------------------
    Caution:
    Oracle recommends that you perform a full backup of all files in the database before using this statement. For more information, see Oracle9i User-Managed Backup and Recovery Guide.

    --------------------------------------------------------------------------------


    Purpose
    Use the CREATE CONTROLFILE statement to re-create a control file in one of the following cases:

    All copies of your existing control files have been lost through media failure.
    You want to change the name of the database.
    You want to change the maximum number of redo log file groups, redo log file members, archived redo log files, datafiles, or instances that can concurrently have the database mounted and open.


    --------------------------------------------------------------------------------
    Note:
    If it is necessary to use the CREATE CONTROLFILE statement, do not include in the DATAFILE clause any datafiles in temporary or read-only tablespaces. You can add these types of files to the database later.

    An alternative to the CREATE CONTROLFILE statement is ALTER DATABASE BACKUP CONTROLFILE TO TRACE, which generates a SQL script in the trace file to re-create the controlfile. If your database contains any read-only or temporary tablespaces, that SQL script will also contain all the necessary SQL statements to add those files back into the database

    http://download-west.oracle.com/docs...htm#SQLRF01203
    Joel Pérez

Posting Permissions

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