| Export a single Table [message #145948] |
Mon, 07 November 2005 17:31  |
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
|
Member |
|
|
Hi,
1. How do we take export backup of a single table....(If you provide syntax,it would be helpful).
Assume :JOB is the Table,man/mal is the username /password..
Thanks in Advance
Regards
Manjunath
|
|
|
|
|
|
| Re: Export a single Table [message #146344 is a reply to message #145948] |
Wed, 09 November 2005 23:40  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
>exp
Export: Release 10.1.0.2.0 - Production on Wed Nov 9 21:38:45 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Username: oradba
Password: <pw>
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 > <hit return>
Export file: expdat.dmp > <hit return or name directory and file>
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U >
Enter T then it asks for the table you want to export
Hit a blank when you are done giving it table names and it will go go go!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
