| |
176 Search Results Found |
| 1 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 16:36 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…got it working. The auto_filter and the nopopulate are apparently incompatible with the directory_datastore. If those are important and you need some sort of substitute or workaround let me know and I will see what i can figure out.
…
|
| 2 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 13:16 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…you!!
Just for my understanding. Why did I need to do that?
Here is my thinking.
I dropped the table, and thus the index was dropped.
I also dropped the preference: KJC_TEST_INDEX_2_NETWORK_PREF
and then recreated.
I then …
|
| 3 |
Forum: Text & interMedia «»
Posted on: Wed, 16 August 2023 17:12 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…am past the Cert error and it is indexing the content of the document. However, it is still incomplete. It is only created 203 tokens off of a 58 page document. It is missing several words, and numbers. It is incomplete. That…
|
| 4 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 08:47 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…is the script that I ran. I had to change a few things in order to get it to run.
commit;
DROP TABLE KJC_TEST_INDEX_2;
CREATE TABLE KJC_TEST_INDEX_2
(assigned_id VARCHAR2(11),
…
|
| 5 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 10:57 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…think I am getting closer. Here is what I have so far, but it is failing. I am getting a certificate error. How do I resolve that? See error message at bottom.
commit;
DROP TABLE KJC_TEST_INDEX_2;
CREATE TABLE …
|
| 6 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 03:17 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…is my test with network_datastore and timeout of 3600 seconds and no_proxy and 'http://www.example.com/index.html'. The error on the dropping of the url_datastore is only because it had been previously dropped, so that can be ignored.
C##…
|
| 7 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 15:24 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…following is a simplified demonstration based on your previous post that shows how to check your index creation for errors and how to create a log of the details of the index process from running the index creation statement, then check that log. I …
|
| 8 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 20:50 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…did not index the document.
Here is the script that I ran:
DELETE FROM KJC_TEST_INDEX_1 WHERE assigned_id = 'MCP-135'
/
INSERT into KJC_TEST_INDEX_1 (assigned_id, text_content_url)
VALUES ('ABC-123', 'http://www.example.com/index.…
|
| 9 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 19:48 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…I ran the script where you changed the names and removed parallel, I got the same results as you. Hopefully, you left everything intact at that point. Please run the script below. I have posted the output that I got below that. If …
|
| 10 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 12:58 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…you change this:
BEGIN
CTX_DDL.CREATE_PREFERENCE('KJC_TEST_INDEX_2_NETWORK_PREF','NETWORK_DATASTORE');
CTX_DDL.SET_ATTRIBUTE('KJC_TEST_INDEX_2_NETWORK_PREF','Timeout','3600');
ctx_ddl.set_attribute
&…
|
| 11 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 30 June 2022 04:36 «»
By: thiyagarajancs
Re: SENDGRID | Curl
…Dears,
I am facing an issue while configuring the email via sendgrid. Kindly help me to resolve the issue.
###########################################Sample Procedure…
|
| 12 |
Forum: Training & Certification «»
Posted on: Thu, 03 January 2002 12:59 «»
By: j.smith
Re: ocp exam
…is the deal. There are hundreds if not thousands of sites out there that allow you to download tests for differnet certification. Most of the test are similar. So the key to passing ORACLE tests is to go onto their website: www.oracle.com and take a look …
|
| 13 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 11:52 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…have modified the script to include this:
BEGIN
CTX_DDL.CREATE_PREFERENCE('KJC_TEST_INDEX_2_NETWORK_PREF','NETWORK_DATASTORE');
CTX_DDL.SET_ATTRIBUTE('KJC_TEST_INDEX_2_NETWORK_PREF','Timeout','3600');
…
|
| 14 |
Forum: Marketplace «»
Posted on: Mon, 03 April 2023 00:05 «»
By: Alexeyg
Meet dbForge Edge - Brand New Multidatabase Solution by Devart
…has released a new multidatabase solution in the dbForge product line - dbForge Edge. The solution includes four database IDEs that cover a wide range of tasks across multiple database management systems.
Devart, one of the leading developers of …
|
| 15 |
Forum: Marketplace «»
Posted on: Fri, 12 August 2022 06:48 «»
By: namviet
Re: McTnsping: a tnsping-like program for Windows
…guys,
Thanks for sharing this application. I reached to this topic when finding the way to validate my ODAC driver installation. I need that ODAC for PowerBi Desktop connection to Oracle. However after installation of ODAC, PowerBI still can´t connect …
|
| 16 |
Forum: Performance Tuning «»
Posted on: Thu, 21 July 2022 10:52 «»
By: Andrey_R
Re: Time metrics in V$SQL don't add up
…seem to be asking for the same thing here in 2010 https://community.oracle.com/tech/developers/discussion/1120738/the-meaning-of-elapsed-time-in-sql
Yet I've seen no good answer.
In one of them, some folks point out to this article https&#…
|
| 17 |
Forum: Marketplace «»
Posted on: Thu, 18 February 2016 12:02 «»
By: Michel Cadot
McTnsping: a tnsping-like program for Windows
…
I have posted a tnsping-like program in our tnsping wiki page.
This is a Windows stand-alone program which requires no Oracle client.
It implements easy connect strings, tnsnames.ora or ldap resolution method.
The help is the following one:
C:\>…
|
| 18 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 02 September 2023 15:09 «»
By: Barbara Boehmer
Re: Jaro-Winkler similarity for 9i
…is my test, removing the diacritical marks and multiplying your result by 100 and rounding it for comparison. It seems to perfectly match Oracle, so if that was the goal then you succeeded, at least with this original dataset.
C##SCOTT@XE_21.…
|
| 19 |
Forum: Backup & Recovery «»
Posted on: Thu, 06 July 2023 09:41 «»
By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…
Thanks John.
I tried to do something similar, but wasn't sure it made sense, and also was hitting some errors, possibly doing other stuff wrong..
So trying now with some more awareness this time :
C:\Users\Administrator>oradim -new -sid …
|
| 20 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 08 March 2023 11:10 «»
By: Barbara Boehmer
Re: Different UTC time from SYSDATE on different databases
…am on Oracle 12c, so I cannot test this, but I see you are on 21c and 19c, where there is a TO_UTC_TIMESTAMP_TZ function that accepts a string representing a DATE with time, that you can get using TO_CHAR on v$session.logon_time and returns a timestamp …
|
| 21 |
Forum: Data Guard «»
Posted on: Sat, 11 February 2023 11:31 «»
By: Andrey_R
Re: RMAN-06820 on rman backup from standby with OS authentication
…you actually do the test, rather than merely speculating, it may become clear that the datafile backup is 100% useless without the redo required to make it consistent.
That's a fair point. So I did:
- Install Oracle 19c EE, no PDB, on Windows Server…
|
| 22 |
Forum: Forms «»
Posted on: Thu, 06 October 2022 16:38 «»
By: brayampettai
CLIENT_TEXT_IO.fopen wont work if Application is started using a
…
I am trying to create a file in a directory in the local machine like c:\myfolder and write data to the file
using the below.
client_text_io.fopen
client_text_io.put_line
client_text_io.fclose
when we access the application from a browser, …
|
| 23 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 04 February 2014 04:02 «»
By: sarfraz_attari
Re: Error in PL/SQL Procedure using UTL_HTTP
…is the URL we are writing on browser to run it
https://www.experttexting.com/exptapi/exptsms.asmx/SendSMS?Userid=MAC&pwd=1833334&APIKEY=efff50e05dc145&FROM=DEFAULT& To=96566466352&MSG="This is a Test mail"
and it is …
|
| 24 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 10 January 2014 15:21 «»
By: BlackSwan
Re: Case statement not working
…a picture of my car.
it is not working.
tell me how to make my car go.
posted SQL contains invalid syntax
since we don't have your tables or data, we can't run, test, debug or improve posted code
Please read and follow the forum guidelines, to…
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 24 December 2013 02:50 «»
By: Michel Cadot
Re: Find no. of times column value modified
Hard to believe.
Try this one: http://www.orafaq.com/wiki/Test_case
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 26 November 2013 03:49 «»
By: rc3d
get data from column name with "ö" (M$ SQL, JDBC) and import it with sqlldr to Oracle
…
with this java code I get the data from SQL Server and write it to a file. This file I would import to Oracle DB.
> cat getDB.java
import java.io.BufferedWriter;
import java.io.FileWriter;
import java.sql.*;
public class getDB {
…
|
| 27 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 26 October 2013 22:33 «»
By: BlackSwan
Re: How to get department wise effective rate
…would be helpful if you provided DDL (CREATE TABLE ...) for tables involved.
It would be helpful if you provided DML (INSERT INTO ...) for test data.
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/311
It…
|
| 28 |
Forum: Training & Certification «»
Posted on: Sat, 24 August 2013 10:16 «»
By: matthewmorris68
Re: OCP query
…Oracle retires exams, there is no effect on people who have already passed them. It simply means that the test will no longer be given in the future.
http://ezinearticles.com/?Oracle-Exam-1Z0-007-Is-Being-Retired:-What-Does-That-Mean-to-Me?&id=…
|
| 29 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 22 August 2013 13:13 «»
By: BlackSwan
Re: How to Show only the address for The Yes Tax Reporting Site
…read and follow the forum guidelines, to enable us to help you:
http://www.orafaq.com/forum/t/88153/0/
Since we don't have your tables or data, we can not run, test, debug or improve posted code.
How will you, I or anyone recognize when correct …
|
| 30 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 15 August 2013 12:20 «»
By: BlackSwan
Re: Syntax for cursors in PL/SQL
…read and follow the forum guidelines, to enable us to help you:
http://www.orafaq.com/forum/t/88153/0/
It is a bad idea to store computed values in a table; since the underlying values may change resulting in wrong data being returned.
Why not just…
|
| 31 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 14 August 2013 04:20 «»
By: flyboy
Re: alternative for pivot stmt
…just reminded me this thread: http://www.orafaq.com/forum/m/546378/0/?srch=Lev_ID_NO_1#msg_546378
As you provided a test case, here is SQL for your case. Just adjust the ordering of numbers according to the requirements (unfortunately you did not …
|
| 32 |
Forum: Performance Tuning «»
Posted on: Sat, 27 July 2013 11:04 «»
By: BlackSwan
Re: Need Help In Performance Tuning
Please read and follow the forum guidelines, to enable us to help you:
http://www.orafaq.com/forum/t/88153/0/
since we don't have your tables or data, we can not run, test, debug or improve posted code.
|
| 33 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 27 June 2013 18:40 «»
By: gusmenp
Error ocurred calling a Web Service using UTL_HTTP
…Hi,
I'm calling a web service with HTTPS protocol from a pl/sql program and i'm using the UTL_HTTP package for do this.
I have a Oracle DB installation 11g Enterprise Edition Release 11.2.0.1.0 on my personal computer with a Windows XP OS, and when …
|
| 34 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 26 June 2013 03:15 «»
By: x-oracle
Re: how to send mail from oracle database
…michel . michel i use smtp_out_server = 'smtp.gmail.com:25' and i remove this line from 11 to 13 now i get this error
SQL> declare
2 begin
3 utl_mail.send(
4 sender => 'test2june@gmail.com',
5 recipients => 'test.june@gmail.…
|
| 35 |
Forum: JDeveloper, Java & XML «»
Posted on: Mon, 04 March 2013 15:14 «»
By: sspn2010
Re: Query help to generate XML
…xmlroot function to include xml version in the query and getting the output as wanted without end tags. Thanks for your help Dariyoosh.
select XMLROOT(xmlelement("Interactions",
XMLAttributes('http://www.w3.org/2001/XMLSchema-…
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 07 November 2012 21:13 «»
By: BlackSwan
Re: Aggregate functions on a join
…would be helpful if you provided DDL (CREATE TABLE ...) for tables involved.
It would be helpful if you provided DML (INSERT INTO ...) for test data.
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/311
It…
|
| 37 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 02 November 2012 17:42 «»
By: BlackSwan
Re: Query without outer join
…would be helpful if you provided DDL (CREATE TABLE ...) for tables involved.
It would be helpful if you provided DML (INSERT INTO ...) for test data.
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/311
It…
|
| 38 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 30 October 2012 11:54 «»
By: BlackSwan
Re: How to get multiple column values in a row
…we don't have your tables or data, we can not compile, run or test posted code.
It would be helpful if you provided DDL (CREATE TABLE ...) for tables involved.
It would be helpful if you provided DML (INSERT INTO ...) for test data.
It would be …
|
| 39 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 25 October 2012 06:21 «»
By: monkey_suit
Re: Converting utl_http.read_text to PDF file
…Michel coupled with your advice and some stuff in the docs and the web i was able to come up with a solution. the only issue i get with this is that when i try to open the pdf it complains that the pdf is already open, when close adobe reader and open it …
|
| 40 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 13 October 2012 18:11 «»
By: BlackSwan
Test Case Builder
…http://optimizermagic.blogspot.com/2008_03_01_archive.html
dbms_sqldiag.export_sql_testcase(
directory => 'TCB_DIR_EXP',
sql_text => 'select count(*) from sales',
testcase => tco)
I just came across …
|
Blog
Search
Help
Members
Register
Login
Home