DBA Data[Home] [Help]

XDB.DBMS_XDBT dependencies on XDB$RESOURCE

Line 76: ' on xdb.xdb$resource p(value(p))' ||

72: END IF;
73:
74: -- Actually create the index
75: sqlstr := 'create index ' || IndexName ||
76: ' on xdb.xdb$resource p(value(p))' ||
77: ' indextype is ctxsys.context' ||
78: ' parameters (''datastore ' || DatastorePref ||
79: ' storage ' || StoragePref ||
80: ' filter ' || FilterPref ||

Line 284: -- Get the tablespace of xdb$resource, that can be considered as the

280: IndexTableSpace VARCHAR2(32);
281: ts_clause varchar2(100);
282: BEGIN
283:
284: -- Get the tablespace of xdb$resource, that can be considered as the
285: -- default tablespace. Only one row can be returned from the query.
286: IndexTableSpace := xdb.dbms_xdb.getxdb_tablespace();
287: ts_clause := 'tablespace ' || IndexTableSpace;
288:

Line 433: FROM xdb.xdb$resource e

429: INTO
430: author, dispname, rescomment, contype, xmlref_lob, xmllob,
431: charset, owneridr, creatoridr, lastmodidr, resextra
432:
433: FROM xdb.xdb$resource e
434: WHERE ROWID = rid;
435:
436: -- get the user names for the owner, creator and the last modifier
437: xdb.dbms_xdbz0.get_username(owneridr, owner);