You can try this
exp system/password file=myfile.dat owner=schema_name rows=n indexes=n
then imp system/password file=myfile indexfile=cr_tables.sql full=y
and you will have your script to create tables and indexes as well for
schema. (Modify script as required ie; remove REM). HTH
Terry Lofgren
Data Base Administrator
Hudson Bay Mining and Smelting Co., Ltd.
P.O. Box 1500
FLIN FLON, MB
R8A 1N9
mailto:terry.[Email Address Removed] 1-204-687-2283
Fax: 1-204-687-2771
-----Original Message-----
From: Deepak Gupta [mailto:[Email Address Removed] Thursday, October 31, 2002 9:55 AM
To: LazyDBA.com Discussion
Subject: Re: How to get the list of the tables
Sorry guys,
I don't want thje list of tables for the schema,
i want to create a script fro create table, with all
it coulmn names , which i cna run to create tables on
the new machine?
Thanks
--- Rachna Vaidya <[Email Address Removed] wrote:
> DBA_OBJECTS would give all the objects for all
> schemas.
> USER_OBJECTS would give all the objects for the
> user's schema.
>
> -Rachna
> ----- Original Message -----
> From: "Farnsworth, Dave"
> <[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed] Sent: Thursday, October 31, 2002 7:06 AM
> Subject: RE: How to get the list of the tables
>
>
> >-Secondly which view to look to find out what a
> schema
> has in it.
>
> SELECT TABLE_NAME FROM DBA_TABLES WHERE OWNER =
> 'Your_Schema_Name';
>
> Dave
>
> -----Original Message-----
> From: Deepak Gupta [mailto:[Email Address Removed] Sent: Wednesday, October 30, 2002 5:44 PM
> To: LazyDBA.com Discussion
> Subject: How to get the list of the tables
>
>
> I am moving the datsabase from one machine to other
>
> I want to create a sql which I can run to create
> tables on the new machine with all the table name
> and
> the columns in it.
>
> Secondly which view to look to find out what a
> schema
> has in it.
>
>
> Please let meknow urgently.
>
> Thanks
>
> Deepak
>
>
> __________________________________________________
> Do you Yahoo!?
> HotJobs - Search new jobs daily now
> http://hotjobs.yahoo.com/
>
> --------
> 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 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 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
>
__________________________________________________
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] 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