-
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
Jeff Hunter
-
Hi,
The first reply posted conforms your requirement.
Additionally you can also try using the COPY command.
Ramki
-
If the table is already created in the target server use the option
ignore=y in the import command
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
|
Click Here to Expand Forum to Full Width
|