need create db script: HELP
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: need create db script: HELP

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Exclamation Urgent. question

    hello all,
    yesterday i installed the oracle 8i from cd. unfortunately it created a starter database and it also installed the binaries. I require a script to help me create a database. please help.
    couldnt find crdb.sql in other oracle home dir.

    Also I installed 8i on linux yesterday at Digiship. I have created a database called DSDEV. and as you know the installer creates some datafiles system, user01, temp01 etc. dbf files. The user wants me to copy over the data from another instance to DSDEV. How do i copy over the datafiles and get the database up and running?

    [Edited by jlakhani on 11-10-2000 at 01:37 PM]

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Configure the new db .. adding/sizing redo logs, adding tablespaces, etc, then export schema from existing db to the new db.

  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Halo i need a script to create the db please

  4. #4
    In Oracle8i you have Oracle Databse Assistant, use it.
    In UNIX is dbassist.
    Ramon Caballero, DBA, rcaballe@yahoo.com

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