Export and import a PPM database

All client-specific data and configurations are saved in the schema of the database user you configured. To back up the data, you only need to export the user's schema via the exp Oracle command. In the command prompt, enter a command line with the following syntax:

exp <DB user>/<password>@<net service name> file=<file name>

To import a backed up PPM database, enter a command line with the following syntax at the command prompt:

imp <DB user>/<password>@<net service name> file=<file name>

Warning

Before importing the non-empty database schema of an existing database user you need to clear the schema by deleting and recreating the database user.

Example: Export a database

To export the schema of the database user umg_en (with the same password) from the ppm_ppmdbsvr database instance to the umg_en.dmp file, enter the following command line in the prompt:

exp umg_en/umg_en@ppm_ppmdbsvr file=D:\dmp\umg_en.dmp

Example: Import a database

To import the schema again, perform the following steps via a command prompt: