3zecisi3 ... DBA experiences
Thursday, December 22, 2011
View user roles in Oracle
›
To view available system privileges, query DBA_SYS_PRIV. SQL> select * from DBA_SYS_PRIVS; To view available roles, query DBA_ROLES....
View SQL text for a specific OS PID
›
To view SQL text for a specific operatig system PID, first you must obtain the sql_id of that process and then select sqlarea to get the sq...
Wednesday, October 19, 2011
Add tablespace containers
›
Din Control Center sau cu SQL se adauga containerele la tablespace Se verifica starea si dimensiunea tablespaces-urilor select sub...
Sunday, September 25, 2011
Rename datafile
›
1. Put tablespace offline sqlplus /nolog SQL> conn admin_user/passwd SQL> alter tablespace TBS offline normal; SQL> exit 2. ...
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....
Tuesday, September 20, 2011
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 Or...
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...
‹
Home
View web version
