Can one export a subset of a table? (for DBA
ORACLE Interview Questions and Answers (Part 5)
(Continued from previous question...)
869. Can one export a subset of a table? (for DBA
From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example:
exp scott/tiger tables=emp query=\"where deptno=10\"
(Continued on next question...)
Other Interview Questions