Oracle : How to export a subset of a table?

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\"

Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)