Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2011
    Posts
    5

    Question Unanswered: Oracle test data

    Hey there. First post. I've been an MV-RDBMS admin for about 10 years and want to work with Oracle. So I've got it down loaded and installed on a P4 2.7GH with 1GB ram and a 1TB drive. I just need test data.

    I know those DB's (Oracle, DB2 and the like) are fickle and difficult to intergrate new data so I am hoping to find a site to download an set of test data so I can start learning mySQL and other Oracle work.

    Can anyone help me?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    What is Operating System name & version?
    post results from SQL below

    SELECT * FROM V$VERSION;
    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
    Nov 2011
    Posts
    5
    Ok I've gotten into the HR sample account and here's the query results

    ----------------------------------------------------------------
    Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
    PL/SQL Release 10.2.0.1.0 - Production
    CORE 10.2.0.1.0 Production
    TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
    NLSRTL Version 10.2.0.1.0 - Production

    SQL>


    THX!

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    below are other schema which can be loaded
    Code:
      1* select username, created from dba_users where length(username) < 3 order by 2
    SQL> /
    
    USERNAME		       CREATED
    ------------------------------ -------------------
    SH			       2010-05-07 11:17:52
    HR			       2010-05-07 11:17:52
    BI			       2010-05-07 11:17:52
    PM			       2010-05-07 11:17:52
    IX			       2010-05-07 11:17:52
    OE			       2010-05-07 11:17:52
    
    6 rows selected.
    http://download.oracle.com/docs/cd/B...llation002.htm
    Last edited by anacedent; 11-05-11 at 00:37.
    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.

  5. #5
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    SQLZoo has published their test data: http://sqlzoo.net/h.htm#data

  6. #6
    Join Date
    Nov 2011
    Posts
    5
    Thanks.... I will get to this asap. Lots to do and a LOT to learn. Again thanks.

    So this is a start. Do you know or have you ever heard mention of a downloadable set of data not supplied with the DB?

  7. #7
    Join Date
    Sep 2011
    Posts
    75
    Quote Originally Posted by ScottJoh View Post
    Hey there. First post. I've been an MV-RDBMS admin for about 10 years and want to work with Oracle. So I've got it down loaded and installed on a P4 2.7GH with 1GB ram and a 1TB drive. I just need test data.

    I know those DB's (Oracle, DB2 and the like) are fickle and difficult to intergrate new data so I am hoping to find a site to download an set of test data so I can start learning mySQL and other Oracle work.

    Can anyone help me?
    Hello,

    You can run the oracle default schema script it get installed with the database itself

Posting Permissions

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