Re: Script to create schema?

  • From: Gints Plivna <gints.plivna@xxxxxxxxx>
  • To: oracledba.williams@xxxxxxxxx
  • Date: Thu, 10 Nov 2005 16:59:42 +0200

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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: