Depends on How far U want to go !

> For a skeleton of the Database do a

sqlplus>alter database backup controlfile to trace;

This would generate a trace file in the ../udump directory

> For entire Database incuding the schemas and schema objects
U can invoke Oracle Database Configuration assistant as

$dbca

and follow the screens to SELECT
> Manage Templates
> Create a Database Template
> From an Existing Database ( with option to include Structure Only or
along with the Data )

===============================================

HTHU

Ankur Shah
Oracle DBA
DHR-GA

----- Original Message -----
From: <christine.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, April 30, 2003 9:16 AM
Subject: How do you script a database in Oracle?


> Hi all,
>
>
> Does anyone know how to generate a SQL script of an existing Oracle
> database? I come from a SQL Server background and I know that in SQL
Server
> Enterprise Manager you can just select the required database and click on
> Generate SQL Script - does something similar exist in Oracle or is it a
lot
> more complicated than that?
>
> Thanks in advance,
> Christine
> _________________________________________________________________
>
> --------------------- End of message text --------------------
>
> This e-mail is sent by the above named in their
> individual, non-business capacity and is not on
> behalf of PricewaterhouseCoopers.
>
> PricewaterhouseCoopers may monitor outgoing and incoming
> e-mails and other telecommunications on its e-mail and
> telecommunications systems. By replying to this e-mail you
> give your consent to such monitoring
>
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page