Oracle imp and exp commands
12,940
You can list tables you want to export or import in your command line as 'tables=...' Or run exp/imp interactively and it will ask you for list of tables. Here is a good FAQ
Comments
-
Vijay almost 2 years
Normally when i have to take a backup of of a database on unix, i do,
exp DBUSER/DBPSW@INST file=xxx.dmp
or load from a dump
imp DBUSER/DBPSW@INST file=xxx.dmp
my question here is :
- how can we take a backup of a single table
- how can we import the data backup from the dump into a single table.
- how can we disable the constraints when taking a backup
I rarely do these when required.some times i need to do the above mentioned things but instead because i donot know i take the complete backup of all the table and load it. does anybody know how we can do it?