Re: How to get the list of the tables

Re: How to get the list of the tables

 

  

Use the import / export utility. Export your schemas on your current DB and
then import it to your new database.



Ruel Rodriguez
Oracle Certified Professional - Application Developer
Global Computer Associates

----- Original Message -----
From: "Deepak Gupta" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, October 31, 2002 7:54 AM
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] 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