| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: recreating a create database file
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 tables and tablespaces.
Ron
>>> [EMAIL PROTECTED] 06/17/03 10:59AM >>>
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.
"Ruth Gramolini"
<rgramolini To: Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
@tax.state.vt.us cc:
> Subject: recreating a
create database file
Sent by:
ml-errors
06/17/2003 10:09
AM
Please respond
to ORACLE-L
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 official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Jun 17 2003 - 10:58:16 CDT
 |
 |