Current location - Loan Platform Complete Network - Big data management - orcl exp export command how to export big data table without exporting data only export table fields
orcl exp export command how to export big data table without exporting data only export table fields
exp h1/h1 file=D:\h1.dmp log=D:\h1.log tables=(h1.table1,h1.table2,h1.table3,h1.table4) rows=n

Mainly, the latter rows=n means that only the table structure is exported but not the data

tables=(h1.table1,h1.table2,h1.table3,h1.table4) rows=n

Mainly, the latter rows=n represents only table structure is exported but not data

tables=(h1.table1,h1.table2,h1.table3,h1.table4) is to export some specified tables