Posts by PedroCamargo • 11 points

• 0

  votes

  1

  answer

  252

  views

  A: SQL Error: ORA-29855: Error in executing ODCIINDEXCREATE routine

  I was able to find the solution: Commando: GRANT CREATE JOB TO ctx_ix_test Link: http://przemyslawkruglej.com/archive/2013/12/text-index-with-a-sync-parameter/…

  oracle oracle11g oracle10g

  answered 5 years, 8 months ago PedroCamargo 11

• 0

  votes

  1

  answer

  252

  views

  Q: SQL Error: ORA-29855: Error in executing ODCIINDEXCREATE routine

  I’m trying to create an index on Oracle where it will be automated and run every hour. Query: CREATE INDEX IX_TXT_NOME ON TBL_PESSOA ("TXT_PESSOA") INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS…

  oracle oracle11g oracle10g

  asked 5 years, 8 months ago PedroCamargo 11

• 0

  votes

  4

  answers

  2042

  views

  A: Select with 3 tables in SQL SERVER

  Also includes a (NOLOCK) not to allocate the tables in processing time SELECT * FROM tblMaquina (NOLOCK) maq INNER JOIN tblEquipamento (NOLOCK) equi ON equi.equId = maq.maqTipoEqui; INNER JOIN…

  sql-server sql-server-express

  answered 5 years, 10 months ago PedroCamargo 11