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
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading