-
Junior Member
Export Import database
How can we copy a file or anything from one database to another database using export and import?
-
Expert Member
Re: Export Import database
This is the example to export a single table
exp scott/tiger file=emp.dmp log=emp.log tables=emp rows=yes indexes=no
To export multiple tables at a time specify table names seperated by , as follows
Tables = (emp,dept,...)
To get further help regarding IMP and EXP go to BIN path of orahome then type
EXP HELP = YES
Last edited by krishnaindia2007; 04-25-2008 at 02:57 AM.
-
Re: Export Import database
what do you mena by copy a file or anything from one database to another database ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules