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?