exp userid=system owner=scott rows=n file=scott.dmpThe OWNER clause denotes the schema you want exported. Only those schemas listed will be in the dump file. The ROWS=N clause tells Oracle not to dump any rows of data. The table structure will be exported but no actual data will be found in the dump file.
Dig deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.