create database script file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: create database script file

  1. #1
    Join Date
    Oct 2000
    Posts
    32
    Can anyone provide a definition for:

    create database scripts file

    ?

    What does it consist of???

    I am doing research elsewhere, but appreciate your expertise.

    Thanks,
    Rara.

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Question contol file to trace


    Do you mean if you backup your controlfile to trace?

    If you do that then you get a create database script in file format. Are you familiar with this? Lemme know.

    - Magnus

  3. #3
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    Magnus -
    You get a CREATE CONTROLFILE script, not CREATE DATABASE. Of course, this script is easily converted to CREATE DATABASE!

  4. #4
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking oh yeah ...


    I see. I forgot. Good point to mention tho. THanks.
    - Magnus

  5. #5
    Join Date
    Oct 2000
    Posts
    32

    I am looking to create a new database using a parameter file (init.ora).

    Well, actually, I am importing a full .dmp onto a new machine. I have default init.ora file that I don't want to use. See? NOw, I am requesting the init.ora file from the dba where the .dmp came from.

    I will need to change the name so that my new database will recognize it, right?

    I need to manually create the database...no default settings, right? This would be done in sql command environment, right?

    I hope you guys can be patient with me.

    I am learning and trying to simply import this file so that we can program from there. If you have any input...

    Is this all I need now: a parameter file and the full .dmp???
    Thanks,
    Rara.

  6. #6
    Join Date
    Oct 2000
    Posts
    24
    I suggest you to use the Oracle database assistant and select expert option. The final option will give you the option to create the database or scripts.


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