The database link name do have dependencies on the global database name.Global database names uniquely identify a database in the system.It is formed from two components: a database name and a domain.The database name and the domain can be determined by the following initialization parametrs:- For database name :- db_name 22:34:00 SYS @ oracle >show … Continue reading DB Link Name and DB Global Name
Logical Standby Out of SYNC
Logical standby going out of sync is a common scenario.But the time of "how much out of sync can it be " depends on the SLA you have.I had a scenario of logical standby going out of the sync and transactions on a particular table consuming is taking time to get applied.The logical standby was … Continue reading Logical Standby Out of SYNC
Silly and Interesting – III
Querying the column name that is not present in the table gives error:- ORA-00904: "COLUMN_NAME": invalid identifier Example:- 20:05:28 SYS @ oracle >desc scott.emp Name Null? Type -------------------------- -------- -------------- EMPNO NOT NULL NUMBER(4) ENAME VARCHAR2(10) JOB VARCHAR2(9) MGR NUMBER(4) HIREDATE DATE SAL NUMBER(7,2) COMM NUMBER(7,2) DEPTNO NUMBER(2) 20:08:32 SYS @ oracle >select d_ename from … Continue reading Silly and Interesting – III
Segment name – Numeric
Last month a question was asked on OTN forum regarding table name where the user had dropped a 450Gb table and while the drop was in progress the user could see a table segment with a weird name "234.16632" of the same size as the original table that being dropped. Link:- http://forums.oracle.com/forums/thread.jspa?forumID=61&threadID=1000550 After a few … Continue reading Segment name – Numeric
Year -2010
Wish you all a very happy , prosperous and wonderful new year 2010 🙂
Learn. Share. Repeat. 