Follow the steps below:
- Log into the Oracle instance as sysdba:
sqlplus '/as sysdba'
- Create a directory for the vcloud dump:
create or replace directory dumpdir_vcloud as '/path/to/where/user/desire';
Note: If this already exists, skip to step 5.
- Verify if the directory name and the path are correct:
SELECT directory_path from dba_directories;
- Grant necessary privileges:
grant read,write on directory dumpdir_vcloud to public;
- Exporting the VCLOUD schema:
Note: This command will provide the VCLOUD schema without the AUDIT_EVENT table. The AUDIT_EVENT table can account over 90% of the database size.
expdp VCLOUD/password dumpfile=mycloudexport.dmp directory=dumpdir_vcloud schemas=VCLOUD exclude=TABLE:\"IN \'AUDIT_EVENT\'\" logfile=vcloud_dumpfile.log
Note: In some cases, the username and schema name may differ. Please adjust the parameters accordingly.
- Before uploading to script server:
- Provide the log file of the datapump dump along with the datapump dump file.
- Zip the database dumpfile before uploading.