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:
sqlplus system@ppm_ppmdbsvr
drop user umg_en cascade
exit
imp umg_en/umg_en@ppm_ppmdbsvr file=D:\dmp\umg_en.dmp