Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Script to create schema?
I'm sure you can find some more or less free tools all around the net to do
that. Some time ago I'v used DataBee from http://www.cool-tools.co.uk/.
So now I'm working as a salesman instead of Mark :))
Gints Plivna
On 11/10/05, Dennis Williams <oracledba.williams_at_gmail.com> wrote:
>
> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 10 2005 - 09:04:27 CST
![]() |
![]() |