Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can one export a subset of a table?

April 26, 2017database DBA export interview Oracle oracle database subset Table

0

Posted

Can one export a subset of a table?

4 Answers

0

Posted

From Oracle 8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. You may need to escape special chars on the command line, for example: query=\”where deptno=10\”.

0

Posted

From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table.

0

Posted

(for DBA From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table.

0

Posted

From Oracle8i, the export utility supports multiple output files. Look at this example:sw(‘pg176707’);..