Re: Generating PL/SQL Script from table
Date: Wed, 20 Aug 2008 10:23:05 -0700 (PDT)
Message-ID: <d6dd4659-1752-4bee-a0f9-55ab2c0c403d@n38g2000prl.googlegroups.com>
On Aug 19, 11: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.
U can create SQL scripts after creating a new Database by running the default script in cmd promt Received on Wed Aug 20 2008 - 12:23:05 CDT