| |
163 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: 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 ...
|
| 24 |
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…
|
| 25 |
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…
|
| 26 |
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 …
|
| 27 |
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
################################################################################
#####
# …
|
| 28 |
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 …
|
| 29 |
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 …
|
| 30 |
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 …
|
| 31 |
Forum: JDeveloper, Java & XML «»
Posted on: Fri, 07 June 2013 02:09 «»
By: Anishkrithik
Creating Oracle Web service in Oracle 11g
…Hi,
We are trying to expose Stored Procedures in Oracle database as Web Services, As part of this, we did below setup and grants for 'TEST' user.
Based on link: http://www.oracle-base.com/articles/11g/native-oracle-xml-db-web-services-11gr1.php…
|
| 32 |
Forum: Networking and Gateways «»
Posted on: Wed, 15 May 2013 17:46 «»
By: skyfx
ORA-12154: TNS:could not resolve service name
…Hi,
So a decent amount of googling suggests that the subject matter error seems to be a fairly common issue. I have found various problem solving guides, but none of them seem to address the issue for me.
What I'm trying to do
Establish a remote …
|
| 33 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 23 March 2013 09:24 «»
By: BlackSwan
Re: Function to insert
Even though twice requested, you have NEVER provided adequate Test Case for whatever you are attempting to do.
http://www.orafaq.com/wiki/Test_case
|
| 34 |
Forum: Training & Certification «»
Posted on: Thu, 14 March 2013 08:11 «»
By: matthewmorris68
Re: Oracle Certification Expiry
You should take 1Z0-144, which is the successor to 1Z0-147 and is a better test in any case.
I wrote an article comparing the two exams here:
http://ezinearticles.com/?Oracle-PL/SQL-Developer-Certification:-1Z0-147-or-1Z0-144?&id=7190832
|
| 35 |
Forum: Server Utilities «»
Posted on: Thu, 07 March 2013 01:22 «»
By: ishika_20
Re: EXP-00008: ORACLE error 904 encountered
…All,
Please find the log...
export logConnected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset …
|
| 36 |
Forum: Training & Certification «»
Posted on: Sun, 17 February 2013 09:06 «»
By: BlackSwan
Re: Test Cases
are both SEARCH & GOOGLE broken for you?
http://www.orafaq.com/wiki/Test_case
|
| 37 |
Forum: Performance Tuning «»
Posted on: Tue, 15 January 2013 08:53 «»
By: alantany
Re: does 11g not do a soft parse when we set cursor_cached_curosr?
…
This is correct for the already parsed statement, and this is correct for any version of Oracle.
Regards
Michel
Hi,Michel
Here is a same test from ASKTOM,the only different is on 8.1.7.
Please look at the "parse count (total)" ,it…
|
| 38 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Thu, 02 August 2012 02:17 «»
By: John Watson
Re: Repository Creation Utility
Test the listener using the address on which it is listening:
sqlplus sys/sys@localhost:1521/orcl.com as sysdba
|
| 39 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 28 July 2012 03:42 «»
By: arash_beterkun
Re: I need to put amount '0' if the row exist but has no amount in my "where " conditions.
…: the link is real . 3 space u need to del.
2nd. its a test case. i did send full result . please just delet '*' from the link mate (2x*).
ht*tp*://www.mediafire.com/?69cc4ay6cyt9cr9
os : win xp
Pl/sql 7.0.2 unlimited user lisence
oci : 9.2…
|
| 40 |
Forum: Training & Certification «»
Posted on: Sat, 21 July 2012 08:48 «»
By: matthewmorris68
Re: Where to get 1z0-047 Oracle Database SQL Expert Master Exam?
…Peter:
You won't find any legitimate practice tests downloadable on the Web. The best (which is also the worst) that you'll find is brain dumps. These are illegitimate study materials and can cost you your certification. The only practice tests that…
|
Blog
Search
Help
Members
Register
Login
Home