Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Script to create schema?

Re: Script to create schema?

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Thu, 10 Nov 2005 16:59:42 +0200
Message-ID: <6e49b6d00511100659m18ed65b3p28d488f6b85100f2@mail.gmail.com>


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-l
Received on Thu Nov 10 2005 - 09:04:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US