RE: Script to create schema?
- From: "Robertson Lee - lerobe" <Lee.Robertson@xxxxxxxxxx>
- To: "Oracle Mailing List" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Nov 2005 14:57:08 -0000
Dennis,
Have you tried
http://www.cool-tools.co.uk/
And looked at the DataBee tool (I believe it is free)
Regards
Lee
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Williams
Sent: 10 November 2005 14:53
To: Oracle Mailing List
Subject: Script to create schema?
List,
I am moving schemas between instances and need to make some schema
changes, like storage sizes. This is Oracle 8i, so I can't use the new
DBMS_METADATA package. Thanks to a tip from Jared Still from several
years back, I take an export file with ROWS=N and filter that with the
Unix strings command. However, there is still a fair amount of editing
to get it shaped up. I started to write a Perl script to do this task,
but thought maybe someone had already done this.
Does anyone have a script that will pretty up the output from the
export? Or a SQL script that extracts a schema in 8i?
Dennis Williams
--
//www.freelists.org/webpage/oracle-l
*************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
*************************************************************************
--
//www.freelists.org/webpage/oracle-l
Other related posts:
