Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Intermedia - escaping words
enclose the the terms in {} contains(column_name,'{UNIX} and {NT}')>0 --Jeff- Jeff6776
- Post #2
- Forum: Oracle: All versions
-
errors creating a functional based index
I've looked up the error message asscociated with ora-01031 and it relates to a user's password changes. Anyone have ideas on how to get a functional based index working. 1 CREATE INDEX table_field_caps_IDX ON table(UPPER(field)) 2 TABLESPACE index_tablespace 3 PCTFREE 10 4*...- Jeff6776
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
Intermedia Indexing
I am trying to create an intermedia index. There are 180K records in the database. Does anyone know how to solve this problem? What exactly is the DRSYS tablespace? SQL> create index IDX_GALE_COMPANY_NAME on GALE (COMPANY_NAME) indextype is ctxsys.context parameters ('storage...- Jeff6776
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
SQLJ problem
Using Oracle 8.1.5 and Sqlj I have a class with a member variable declared as such. private ExecutionContext context = new ExecutionContext(); Here is my code to set the rollback segment try{ #sql [context] { set transaction use rollback segment R01 }; }...- Jeff6776
- Thread
- Replies: 1
- Forum: Oracle: All versions
-
Oracle Certification
Does anyone have an estimate on how long it takes to pass all 5 dba tests for OCP DBA certification for someone with say 1)no experience or 2)sql/plsql experience or 3)amateur database administration experience- Jeff6776
- Thread
- Replies: 4
- Forum: Oracle: All versions
