Hi Sreenivas,

The export script below is the answer to your question: first export the
schema, then use the import with the following options ROWS=N SHOW=Y. What
this does is write the SQL into the log file, you can later run this code
after some minor reformating.

Regards,

Joseph

exp system/[Email Address Removed] COMPRESS=Y DIRECT=Y file=FIN_JOSEPH_12112002.dmp
LOG=FIN_JOSEPH_12112002.log owner=joseph

IMP system/[Email Address Removed] FULL=Y ROWS=N SHOW=Y
file=FIN_JOSEPH_12112002.dmp LOG=SCHEMA_JOSEPH.LOG


----- Original Message -----
From: "Sreenivas Sri" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Monday, December 30, 2002 2:18 PM
Subject: extract tablespace definition script


>
>
> Gurus,
>
> could some body help me with the script to extract the tablespace
definition
> script from source database... which I want to run on destination database
> before importing the export dump taken from source database.
>
> TIA,
>
> Sreenu
>
>
>
>
> >From: Rathi Dhanvir <Dhanvir.[Email Address Removed] >To: "LazyDBA.com Discussion" <[Email Address Removed] >Subject: RE: any Free Dowloadable Oracle monitoring Tools ?
> >Date: Tue, 24 Dec 2002 08:10:44 -0000
> >
> >Sorry its www.keeptool.com
> >
> >-----Original Message-----
> >From: Rathi Dhanvir
> >Sent: Tuesday, December 24, 2002 13:38
> >To: 'VIVEK_SHARMA'; LazyDBA.com Discussion
> >Subject: RE: any Free Dowloadable Oracle monitoring Tools ?
> >Importance: High
> >
> >
> >www.keeptool.com
> >
> >hope this site will help you.
> >
> >regards
> >Dhanvir
> >
> >-----Original Message-----
> >From: VIVEK_SHARMA [mailto:[Email Address Removed] >Sent: Tuesday, December 24, 2002 13:16
> >To: LazyDBA.com Discussion
> >Subject: any Free Dowloadable Oracle monitoring Tools ?
> >
> >
> >
> >any Free Dowloadable Oracle monitoring Tools Along with features
> >Comparative
> >to OEM ?
> >
> >
> >
> >
> >
> >
> >--------
> >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
> >
>
>___________________________________________________________________________
_
> >________________________
> >Churchill the nodding dog has recorded a Christmas single - 'No Limits'
by
> >Bakshelf Dog. On sale from 9th
> >December, all profits will be donated to the National Canine Defence
> >League..
>
>___________________________________________________________________________
_
> >________________________
> >
> >
> >This email and any attached to it are confidential and intended only for
> >the
> >individual or
> >entity to which it is addressed. If you are not the intended recipient,
> >please let us know
> >by telephoning or emailing the sender. You should also delete the email
> >and
> >any attachment
> >from your systems and should not copy the email or any attachment or
> >disclose their content
> >to any other person or entity. The views expressed here are not
> >necessarily
> >those of
> >Churchill Insurance Group plc or its affiliates or subsidiaries. Thank
you.
> >Churchill Insurance Group plc. Company Registration Number - 2280426.
> >England.
> >Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
> >1DP.
> >
> >
> >
> >--------
> >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
>
>
> _________________________________________________________________
> Protect your PC - get McAfee.com VirusScan Online
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
>
> --------
> 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