recipients of list ORACLE-L
Sent: Tuesday, June 17, 2003 1:29
PM
Subject: Re: recreating a create database
file
Ruth,
Ummm how did you do this in 9i?
Thanks,
-LizzRuth Gramolini [EMAIL PROTECTED]
wrote:
I
got the answer, thanks anyway. Ruth- Original Message
Thanks, Mladen. I will look forward to it. Meanwhile, I at least have
something to recreate them as they are.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 12:40 PM
I have it at home. It's a modified version of the
Good morning all,
Somehow all of my scripts to create the databases on my 9i sandbox have
disappeared. Does anyone have a script or trick or something to recreate
these files? I could recreate them manually but I am somewhat of a time
crunch.
Thanks in advance,
Ruth
--
Please see the
: recreating a create database
file
Sent by:
ml-errors
Maybe not exactly what you are looking for, but
Start the GUI DBCA (NO don't shoot), go through the all the motions and at
the end choose generate scripts only.
Jack
-Original Message-
Sent: Tuesday, June 17, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L
Good
I got the answer, thanks anyway.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 10:09 AM
Good morning all,
Somehow all of my scripts to create the databases on my 9i sandbox have
disappeared. Does anyone have a
]
@tax.state.vt.us cc:
Subject: recreating a
create database file
Message-
From: Ruth Gramolini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Subject: recreating a create database file
Good morning all,
Somehow all of my scripts to create the databases on my 9i
sandbox have
disappeared. Does
:
Subject: recreating a
create database file
Sent by:
ml-errors
I have it at home. It's a modified version of the script
in Orac_Dba, concocted by Jared Still and Andy Duncan. You
can get the script from CPAN and I'll send you my version
when I get home. I've even sent it to Jared and Andy, but I
don't have time to maintain Orac_Dba right now. May be Jared
Not sure if this was already mentioned. You can hack up the result of
this:
alter database backup controlfile to trace;
into an exact replica of the create database statement.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 17 Jun 2003, Jack van Zanen wrote:
Maybe not exactly
Tom,
Yes the trace file is a good idea for scripting the database ut it
does not create any of the tables and other options available in Oracle.
You will still need all of your scripts or other package to completely
recreate your database.
That is if the interpretation of a database is more than
Ron,
I read Ruth's original message meaning that she had to re-create the
database structures. Of course you are correct if she meant the schema
objects also.
I just liked Jeremiah's thinking - this is an excellent quick way of
creating the create database script to re-create all of the
popping my head out the window...
Here is the create script I just did for 9i
[createdb.sql]
spool DB_DESTINATION\admin\INSTANCE\create\CreateDB.log
set echo on
connect SYS/PASSWORD as SYSDBA
startup nomount
pfile=DB_DESTINATION\admin\INSTANCE\pfile\initINSTANCE.ora;
-- build the db
CREATE
14 matches
Mail list logo