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
Do you need the CREATE DATABASE ... script or the scripts to create all
the database objects. If it's the latter and you have an export, import
that into an IFILE and remove all the REMs. That should give you the
tablespaces, tables, and indexes. You'll have to do some manual
formatting.
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
Ruth,
If you have the DataBee tool (available free )
http://www.cool-tools.co.uk You can take an export and then the
commands are available to recreate your tables and tablespaces.
Ron
[EMAIL PROTECTED] 06/17/03 10:59AM
Do you need the CREATE DATABASE ... script or the scripts to create
all
Well ... here is some generic stuff for you to edit. This is from 8.1.x,
but I think it will still (with an edit or two) get you a running database
in 9.2.x
connect / as sysdba
startup nomount
create database CRCT2
maxinstances 8
maxlogfiles 32
character set US7ASCII
datafile
Thanks Ron :)
Mark
Cool-Tools
-Original Message-
Ron Rogers
Sent: 17 June 2003 17:10
To: Multiple recipients of list ORACLE-L
Ruth,
If you have the DataBee tool (available free )
http://www.cool-tools.co.uk You can take an export and then the
commands are available to recreate your
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
13 matches
Mail list logo
