Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is index on sys.syn$ missed?
Hi,
Why did Oracle not index columns owner and name in table sys.syn$? Now it is impossible to find quickly all synonyms for the given object.
This is definition from 8.0.3. The same is in 7.2.2.
CREATE TABLE "SYN$"
("OBJ#" NUMBER);
,"NODE" VARCHAR2(128)
,"OWNER" VARCHAR2(30)
,"NAME" VARCHAR2(30)
CREATE UNIQUE INDEX "I_SYN1" ON "SYN$"("OBJ#"); Andrew Protasov Received on Thu Nov 12 1998 - 10:00:07 CST