Re: Generating PL/SQL Script from table

From: <fitzjarrell_at_cox.net>
Date: Tue, 19 Aug 2008 11:50:16 -0700 (PDT)
Message-ID: <2ab26243-0166-4211-89e9-d20b9416b1bb@m44g2000hsc.googlegroups.com>

On Aug 19, 1:40 pm, tcole6 <tco..._at_gmail.com> wrote:
> Sorry to keep asking SQL Server to Oracle questions...
>
> Within SQL Server, once I create a database, related tables, triggers,
> etc. I can automatically generate SQL scripts (through the Enterprise
> Manager) to duplicate the database and all related tables, triggers
> etc on another instance of SQL Server.  Then all I have to do is
> execute these scripts in Query Analyzer of another system and viola,
> there is my database, tables, triggers, etc.
>
> Is there such a function within the Oracle Enterprise Manager Console?
> I am running 9i.
>
> Thanks.

With Oracle that's known as the exp utility, and a full export will,

with some reservations, create a file which will, when imported into a
newly created database, duplicate a database at the schema level;
tables, indexes, views, packages, procedures, functions, triggers,

types, etc. are all duplicated into the destination database.

David Fitzjarrell Received on Tue Aug 19 2008 - 13:50:16 CDT