Rename datafile

1. Put tablespace offline


sqlplus /nolog
SQL> conn admin_user/passwd
SQL> alter tablespace TBS offline normal;
SQL> exit


2. Copy or move datafile to new location using OS command cp


cd /u02/oradata/olcl
mv TBS_reorg0.dbf TBS.dbf


3. Change tablespace definition, renaming datafile


sqlplus /nolog
SQL> conn admin_user/passwd
SQL> alter tablespace TBS rename datafile '/u02/oradata/olcl/TBS_reorg0.dbf' to '/u02/oradata/olcl/TBS.dbf';


4. Put tablespace online


SQL> alter tablespace TBS online;
SQL> exit

ORA-20446: The owner of the job is not registered

This error appears in Enterprise Manager 11g when running a job


Solution:


sqlplus /nolog
conn sysman/passwd
SQL> execute MGMT_USER.MAKE_EM_USER(‘USERID’);

ORA-00600: internal error code, arguments: [kwqbdrcp101], [], [], [], [], [], [], []

In case of error ORA-00600: internal error code, arguments: [kwqbdrcp101], [], [], [], [], [], [], [] in alert.log, and you are using Oracle Streams

Stop propagation

exec DBMS_PROPAGATION_ADM.STOP_PROPAGATION('"[nume_propagare]"');

Drop propagation process

exec DBMS_PROPAGATION_ADM.DROP_PROPAGATION('"[nume_propagare]"');

Empty queue table for capture process

DECLARE

options dbms_aqadm.aq$_purge_options_t;

BEGIN

options.delivery_mode:=DBMS_AQADM.BUFFERED;

DBMS_AQADM.PURGE_QUEUE_TABLE('"[administrator_streams]"."[nume_captura]_QT"',NULL,options);

END;

/

Oracle Streams Apply

To tell Apply Process from Oracle Streams to ignore old values for columns at update or delete time: 

begin

dbms_apply_adm.compare_old_values(

object_name => '[nume_schema].[nume_tabela]',

column_list => '*',

operation => '*',

compare => FALSE);

end;

/