| |
183 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: General «»
Posted on: Mon, 15 March 2021 07:16 «»
By: deepakdot
Oracle Licensing
…sure, if this is the right place to put this Question here.
Is Oracle free for the development ?
Lets say In an Organization, developers want to install Oracle Personal Edition in the local laptop, so that they can perform the unit test before …
|
| 24 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Wed, 15 April 2020 04:47 «»
By: John Watson
Serving APEX images from the Oracle CDN
…our developers asked me to look at this
https://blogs.oracle.com/apex/announcing-oracle-apex-static-resources-on-oracle-content-delivery-network
and consider using Oracle's CDN for the images rather than having my Apache reverse proxy serve them.
So …
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 26 February 2020 01:37 «»
By: Michel Cadot
Re: Get (and lock) first unlocked row?!
…
Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.
Create a new topic …
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 21 September 2015 02:42 «»
By: flyboy
Re: merge statement (merged :)
…that is exactly what the SQL you posted does (I only with renamed column CORE_PHOTO_URLS_TEST.PROPERTY_ID to PROP_ID, as it changed in the test case):
SQL> column photo_url format a80
SQL> select prop_id, photo_url_num, photo_url from …
|
| 27 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 06 July 2015 10:27 «»
By: BlackSwan
Re: To get start and end date of month
Please read and follow the forum guidelines, to enable us to help you:
http://www.orafaq.com/forum/t/88153/0/
please provide us Test Case & show us desired/expected results
|
| 28 |
Forum: Training & Certification «»
Posted on: Thu, 04 June 2015 14:48 «»
By: matthewmorris68
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities
…is directed specifically at Kevin. Someone asked me on the OTN certification forum for a SQL tuning book to help them prepare for certain aspects of the 1Z0-117 SQL Tuning certification exam. I suggested that he open a thread on OraFAQ and ask you if …
|
| 29 |
Forum: JDeveloper, Java & XML «»
Posted on: Fri, 15 May 2015 02:46 «»
By: kytemanaic
Re: Is it possible to retrieve an array of pl/sql record which contain DATE elements in Java
…Anil, if your solution requires Oracle Application Framework to be installed, then I afraid the solution is not applicable to me. I'm running the java application on eclipse, Jdk 1.7.0_71
I got the following solution but have some warnings: Map is a …
|
| 30 |
Forum: Server Administration «»
Posted on: Wed, 22 April 2015 09:26 «»
By: EdStevens
Re: DB Restart after Table Partition
…
No need to depend on the IT organization to provide a test environment. The OP should create his own with VBox. see: http://edstevensdba.wordpress.com/category/opinion/ (Create your own test system)
Edit : As Gazzag pointed out, this is the …
|
| 31 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 14 April 2015 02:25 «»
By: Roachcoach
Re: SQL Query
We don't do homework.
Please read this http://www.orafaq.com/forum/t/88153/0/ amend your post accordingly with a test case and show us what you tried.
|
| 32 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 04 February 2014 02:15 «»
By: sarfraz_attari
Error in PL/SQL Procedure using UTL_HTTP
…all
We need to send SMS to our customers through Oracle PL/SQL Procedure
We prepared the procedure as attached
But when we are running the procedure following error appears
SQL> connect whadmin/whdev@dev
Connected.
SQL> set serveroutput on
…
|
| 33 |
Forum: Server Utilities «»
Posted on: Tue, 29 October 2013 09:10 «»
By: Michel Cadot
Re: Run Exp utility in background mode
exp username/"$12300$ahhh"@test.cis.cat.com ...
|
| 34 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 10 October 2013 13:38 «»
By: BlackSwan
Re: Creating views - percentages and multiple tables. Newbie
…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…
|
| 35 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 22 September 2013 11:35 «»
By: BlackSwan
Re: how to get Max(value) with its corresponding datetime ...
…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…
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 13 August 2013 23:17 «»
By: BlackSwan
Re: PL/SQL Open cursor Parameters
…& foremost, remove, delete, eliminate the whole & complete EXCEPTION handler!
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't …
|
| 37 |
Forum: Unix «»
Posted on: Mon, 22 July 2013 18:28 «»
By: swapnabpnn
Re: if record count is zero in file,need to report
…about that,Please find below the test results of the code.
################################################################################
#####
SALE_LOC=$1
################################################################################
#####
# …
|
| 38 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 28 June 2013 12:00 «»
By: BlackSwan
Re: Query issue
…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 test, run, improve, or debug posted SQL
what exactly is below supposed to do or …
|
| 39 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 20 June 2013 19:43 «»
By: BlackSwan
Re: Oracle DB 11g "LEVEL" issue
…>With LEVEL pseudo column, This is returning all the records AND it is not considering where condition
the single record returned above appears to be correctly handling WHERE clause.
how can we reproduce what you claim?
Please read and follow …
|
| 40 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 11 June 2013 23:50 «»
By: Lalit Kumar B
Re: Need help to read CLOB and use in SQL query
…of all, please let me know how did you do this:-
insert into test(col2,col5) values(1,'...text > 4000 char...');
It will always throw an error saying "ORA-01704: string literal too long".
OERR lookup says:-
ORA-01704: string literal …
|
Blog
Search
Help
Members
Register
Login
Home