Micronet800.co.uk

Checking Status of datapump jobs You can attach to a running job at any time to check the status. To attach to an export job, issue an expdp command, using the ATTACH parameter to specify the job name ie: expdp gennick/bramell attach=TEST shows an attach to the TEST job. When you attach to a job,…

To query Oracle to find the schema size run the following sql: select owner,sum(bytes) from dba_segments group by owner; If you do not have dba privs then use the table user_segments instead of dba_segments.

Performing a datapump export See what directories are already setup: SELECT * FROM dba_directories If you need to create a new location: CREATE DIRECTORY dmpdir AS ‘/opt/oracle’; GRANT read, write ON DIRECTORY dmpdir TO scott; Export the data expdp schemas=xxxxx direcotry=dmpdir filename=filename .

Some quick notes on removing Oracle Nodeapps in a cluster. Take a note of current config of node using:  srvctl config nodeapps -n nodename -a To remove nodeapps:  srvctl remove nodeapps -n o2hp113 To re-create:  srvctl add nodeapps -n nodename -o $ORACLE_HOME -A xxx.xxx.xxx.xxx/255.255.255.0/laninterface .