Hi all,
How do I export and import one single table from one server to another. I am using Oracle 8.1.6 on Solaris.
Thanks for any help.
Printable View
Hi all,
How do I export and import one single table from one server to another. I am using Oracle 8.1.6 on Solaris.
Thanks for any help.
1. exp owner/password file=exp.dmp tables=xyz
2. ftp file in binary mode to new server
3. imp owner/password file=exp.dmp full=y
Hi,
The first reply posted conforms your requirement.
Additionally you can also try using the COPY command.
If the table is already created in the target server use the option
ignore=y in the import command