11/2/09

Oracle xe Backup and Restore for Windows

Export

To dump a single schema to disk use this command

- Open a command prompt and navigate to the server\bin folder and execute this command:

exp user/password FIlE=schemaname.dmp OWNER=schemaname

Import

imp user/password FIlE=schemaname.dmp

1 comment: