| |
141 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: Thu, 12 September 2019 00:29 «»
By: OraFerro
Aggregate operation on array - get totals
…All,
This post is similar to my previous post (http://www.orafaq.com/forum/m/676470/#msg_676470) but this time I am seeking advice regarding a smarter way to accomplish what I want.
I have a query (complex and resource consuming in the real world) …
|
| 27 |
Forum: Client Tools «»
Posted on: Wed, 12 December 2018 07:03 «»
By: EdStevens
Re: SQL Developer Database Diff...
…
Ok, having never used DIFF myself, I did set up a test. I couldn't find anything that suggested that it would actually execute the DDL. And there doesn't seem to be anything in the docs to suggest that it would actually execute the DDL.
And FWIW, I…
|
| 28 |
Forum: Client Tools «»
Posted on: Thu, 22 November 2018 10:11 «»
By: cookiemonster
Re: Invalid User Name (ORA-01017)
I suggested to use upper case TEST yesterday & was ignored.
http://www.orafaq.com/forum/mv/msg/205319/673509/#msg_673509
That post doesn't mention actually recreating the user at any point.
You short-hand way too much.
|
| 29 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 14 August 2018 15:07 «»
By: vharish006
XML Special Character
…All,
I'm trying to develop a report and facing below error with one Column "Sub_market_type" having some special Characters like '&'
"The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct …
|
| 30 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 20 November 2017 04:29 «»
By: _jum
Re: Query Analysis
…ORACLE 12 you can use LATERAL to avoid the TABLE CAST construct:
WITH test_compare (url_list) AS
(SELECT 'AA-HTTP://AA.COM, AC-HTTP://AC.COM,CC-HTTP://CC.COM, CA-HTTP://CA.COM' FROM dual),
test_cc(cc_code) AS
(SELECT 'AA' FROM dual UNION …
|
| 31 |
Forum: Training & Certification «»
Posted on: Thu, 17 August 2017 14:45 «»
By: BlackSwan
Re: Oracle SQL 1Z0-071
…
matthewmorris68's Profile
Date Registered: Thu, May 24, 2012
Message Count: 258 Messages (0.13 average messages per day)
Show all messages by matthewmorris68
Status: Senior Member
Avatar:
Last Message: Mon, 24 October 2016 11:15
Re: Test …
|
| 32 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 14 June 2017 10:05 «»
By: BlackSwan
Re: Help the newbie to do my first procedure
http://www.orafaq.com/wiki/Test_case
|
| 33 |
Forum: Training & Certification «»
Posted on: Mon, 24 October 2016 11:06 «»
By: ChuckHennet
Test Strategy Still Valid? -- Matt Morris Article
…the suggestions from this article still applicable to the 12c exams? I didn't know if the exam format had changed from 11g.
http://www.gocertify.com/articles/oracle-certification-study-tips.html
Tip #8 -- Don't skip questions
If you get to a …
|
| 34 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 01 October 2016 17:02 «»
By: Barbara Boehmer
Re: Default Character type of the column
…nls_length_semantics determines whether byte or char is used. This is set in the nls_database_parameters, which can be overridden for the session in the nls_session_parameters. As you have already found, you can also override both in your table creation…
|
| 35 |
Forum: Spatial «»
Posted on: Wed, 22 June 2016 03:52 «»
By: Barbara Boehmer
Re: Update-SET Query for multiple rows
I don't know of a substitute method in locator and don't have it to test with. You might try the OTN spatial forum:
https://community.oracle.com/community/database/oracle-database-options/spatial/content
|
| 36 |
Forum: Server Administration «»
Posted on: Thu, 04 February 2016 18:05 «»
By: juniordbanewbie
Re: Will a Bigger Next Extent Results In Smaller Fragmentation
…you saying that you store your data directly on internal disks and do not use SAN/NAS?
=> I don't know. just being shot an email from my department head on customer complaining that when creating tablespace to be autoextend on next 2m it causes disk …
|
| 37 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 09 November 2015 10:42 «»
By: flyboy
Re: PLSQL Collection index by varchar
…Hi,
There is nothing like "repeating values" for one index, it is the same situation as one variable may hold only one value - it is overwritten by the latest assignment.
According the work with the associative array, consider consulting …
|
| 38 |
Forum: RAC & Failsafe «»
Posted on: Sat, 26 September 2015 09:21 «»
By: juniordbanewbie
Cannot connect through single client access name scan after 1st node pubic cable is plugged off
…all,
I pull out a public cable from imdb01, expecting that imdb01-vip will failover and all db connections to switch to imdb02
Here's my observation:
oracle@imdb02:~> srvctl status vip -n imdb01
VIP imdb01-vip is enabled
VIP imdb01-vip …
|
| 39 |
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 …
|
| 40 |
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
|
Blog
Search
Help
Members
Register
Login
Home