Syntax for export utility in Oracle 9i

We are using Oracle 9i and we want to use the export utility to export the database. How do I write the syntax for the exp utility?

Brian Peasland

Published: 24 May 2007

We are using Oracle 9i and we want to use the export utility to export the database. I'm not familiar with the exp syntax. Can you just tell me how to write the syntax for the exp utility? We want to take a full database backup.

If you want to export the entire contents of the database, then use the following:

exp userid=system/manager file=full_exp.dmp full=y

There are many other parameters for the exp utility. You can find all of the parameters documented in the Oracle documentation.

Dig Deeper on Oracle database backup and recovery

Related Q&A from Brian Peasland

Managing Oracle connections from third-party apps

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading

Syntax for export utility in Oracle 9i

We are using Oracle 9i and we want to use the export utility to export the database. How do I write the syntax for the exp utility?

Dig Deeper on Oracle database backup and recovery

VMware OVF Tool (VMware Open Virtualization Format Tool)

Data export command: Migration from a DB2 table to a flat file

Oracle error 6550 may mean incorrect Oracle export version

Importing and exporting bulk data with SQL Server's bcp utility