Import and Export

[Amod Deshpande]

Hi,
I am new to oracle. I need to import all the tables from one oracle database to another oracle database.
Can anyone tell me the import and export scripts which i need for the same?
Also can any one tell me if views can also be imported or updated when database is imported?
Thanx in advance
Amod

[Nagendra Prasad]

just run the export command on the source database.
run export in the interactive mode.
perform full user export if it is schema u are interested in.
When importing,
run import from the command line.. point to the dmp file obtained from the export. If the user to which u are importing to is different, use
the fromuser and touser tags.
for more details, check the OTN site.
For help type exp help=y or imp help=y
hope this helps

[Mark Spritzler]

Also can any one tell me if views can also be imported or updated when database is imported?

Yes, using the Imp and exp programs you can have them export and import all types of objects.
Mark