Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2010
    Posts
    2

    Unhappy Unanswered: Best way to Creating Oracle DB Test??

    Hi folks!

    I am Oracle developer but I have been assigned some DBA stuff which makes me crazy. I am creating oracle db test from production which is almost 3TB, My approach was to crate dmp files schema by schema then import into test database. When I ran the export command it took almost a day and did not finish. This approach looks does not work fine for me. I searched online, end up getting "data pump" but did not work for me either, I am using Oracle 9i and this seems to work for 10g>.

    Fellows what is the best way to do this?

    Production is running Oracle 9i in Sun Microsystem

    I have installed Ubuntu and Oracle 10g in another server for my test database.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Production is running Oracle 9i in Sun Microsystem
    datapump does not exist for V9

    since you are going between different OS; export & import are only option.

    FWIW - ubuntu is not a supported OS for Oracle.

    Code:
    bcm@bcm-laptop:~$ uname -a
    Linux bcm-laptop 2.6.32-22-generic #36-Ubuntu SMP Thu Jun 3 19:31:57 UTC 2010 x86_64 GNU/Linux
    bcm@bcm-laptop:~$ sqlplus
    
    SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 15 11:07:34 2010
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    Enter user-name: / as sysdba
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2010
    Posts
    2
    Hi Anacedent,

    Thanks for a quick reply. Yeah Ubuntu is not supported for Oracle. I have done this for the purpose of test. The installation went fine and the database is up and running in Ubuntu. Do you advise me to change OS?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I showed you that I am running UBUNTU myself; even though Oracle does not support it.
    You are free to use what ever you deem appropriate.
    Oracle RDBMS does not really know or care what OS is underneath it.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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