I've created the following function: CREATE OR REPLACE FUNCTION squeeze_partnumber( inp_part_number IN VARCHAR2 ) RETURN VARCHAR2 DETERMINISTIC AUTHID...
David Medinets
medined@...
Mar 6, 2002 1:36 pm
22
Hi all, ... Plan Table ... Plan Table ... Sql: select /*+ ordered */ ... From pvcatalog pvcat, stfdescm Cf, pvtechvw V, stockm s Where ( ...
Sri Harsha
harshaskm@...
Mar 6, 2002 1:36 pm
23
For whatever reason, the AUTHID CURRENT_USER clause in the function definition caused the error when the index was created. I'm hoping this is a bug because I...
David Medinets
medined@...
Mar 6, 2002 2:48 pm
24
I am running Oracle 8i on Windows NT. I wanted to check for corrupt blocks in a data file, so I ran DBVERIFY. The following message was returned: "Specified...
Barbara Samlok
b.samlok@...
Mar 6, 2002 2:51 pm
25
1. Have the all the tables in the query been analyzed to either compute or estimate statistics? If not, the Cost Based Optimizer won't have accurate...
mjfierst@...
Mar 6, 2002 2:51 pm
26
My guess is that AUTHID CURRENT_USER makes the function dependent on state information (who is the current user) and therefore cannot be deterministic and...
Henry R. Miller
hmiller@...
Mar 6, 2002 5:48 pm
27
Hi David, Repect the order on those parameter: 1. AUTHID CURRENT_USER 2. DETERMINISTIC 3. PARALLEL_ENABLE So try this: CREATE OR REPLACE FUNCTION...
Regis Biassala
regis.biassala@...
Mar 6, 2002 5:48 pm
28
I'm new to this but, when you use functions (TRIM) on the columns aren't the indexs not used....
rspaeth2001@...
Mar 6, 2002 5:50 pm
29
Actually, I just ran some simple tests, and it doesn't appear that using the TRIM function is enough to prevent using an index. But in general, you are right:...
mjfierst@...
Mar 6, 2002 9:59 pm
30
According to the Oracle Utilities Manual under DBVERIFY parameters: BLOCKSIZE BLOCKSIZE is required only if the file to be verified has a non-2kb block size....
Mark C. Stock
mcstock@...
Mar 6, 2002 9:59 pm
31
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: "Kalpesh Jani" <janik29@...> Hi Barbara, Run this...
Hi David, Repect the order on those parameter: 1. AUTHID CURRENT_USER 2. DETERMINISTIC 3. PARALLEL_ENABLE So try this: CREATE OR REPLACE FUNCTION...
Regis Biassala
regis.biassala@...
Mar 7, 2002 6:02 am
33
I haven't studied your query extensively, but the first thing that strikes me is that it has a lot of ORs and function calls, both of which can disable ...
John Flack
johnf@...
Mar 7, 2002 7:44 am
34
+ Interjection by listserv moderator: + Several helpful replies to this posting come + to similar conclusions, below... ... From: "O'Neill, Sean"...
Virginia Oracle User'...
VOUGlist@yahoogroups....
Mar 7, 2002 7:47 am
35
I think I can see a valid reason for the CREATE FUNCTION to succeed, but for the CREATE INDEX to fail -- it would have to do with different scopes of the ...
Mark C. Stock
mcstock@...
Mar 7, 2002 4:10 pm
36
When you run the dbv command, you need to specify your blocksize. dbv file=filename blocksize=your block size ... From: Barbara Samlok...
Haller, Melissa
mhaller@...
Mar 7, 2002 4:10 pm
37
The clause in question is the join condition for the tables: PVCATALOG (PVCAT) -- 634 qualifying rows STFDESCM (CF) -- 4k qualifying rows The assumption is...
Mark C. Stock
mcstock@...
Mar 7, 2002 4:13 pm
38
Here is my functional index definition from Oracle Enterprise Manager: CREATE INDEX "COMDOTS"."IDX_SQUEEZE_PARTNUMBER" ON...
David Medinets
medined@...
Mar 7, 2002 4:47 pm
39
Harsha, In general, the use of functions like NVL, TO_CHAR and TRIM will force the optimizer to abandoned indexes in favor of a full table scan. At a high...
Robert Webb
rwebb@...
Mar 7, 2002 4:57 pm
40
Matt, Using an expression or a function on a column(s) in a WHERE clause predicate will prevent available indexes for that specific column(s) from being ...
Mark C. Stock
mcstock@...
Mar 7, 2002 5:21 pm
41
Hi Barbara, Run this command when you are not using default OS blocksize - most of the time 2048 for NT. dbv blocksize=8192 file=tbs_52.f Where blocksize is...
Kalpesh Jani
janik29@...
Mar 7, 2002 7:38 pm
42
Dave, Sorry I don't have time to dig into the details of this now, but a few thoughts come to mind: 1) are all required INIT.ORA parameters and session...
Mark C. Stock
mcstock@...
Mar 7, 2002 8:09 pm
43
Does anyone have a framework they use to generate test data? ... I'm thinking of using the following sql as a template to select a random record from a table...
David Medinets
medined@...
Mar 8, 2002 5:59 pm
44
Hi all, Thanx for the replies, i tried to hint the sql in using the indexes but the cost is increasing, and i wont be able to remove the trim function because...
Sri Harsha
harshaskm@...
Mar 10, 2002 2:33 pm
45
Hi All, DBV with 8i(8.1.6) on NT has a bug, you'll find it in Metalink. And it has been corrected in ver.8.1.7 I hope you are not trying the command on 8.1.6!!...
Sri Harsha
harshaskm@...
Mar 10, 2002 2:34 pm
46
Oooh, I hate installing third party packages, particularly those that use ODBC and are designed to work with a number of different relational databases. They...
John Flack
johnf@...
Mar 12, 2002 12:54 pm
47
Hello, I am working on a PL/SQL script that will prompt the user to enter two values using the Accept command, and will hold the values entered in 2 variables...
Phillip Small
psmall57@...
Mar 12, 2002 6:03 pm
48
Hello, I was wondering if anyone out there would be able to help me with the SQL syntax to count the # of Inserts/Updates that have been carried out on a table...
Colin Peppy
cpeppy@...
Mar 12, 2002 6:04 pm
49
+ Interjection by listserv moderator: + Tons of helpful responses to this posting, below... ... From: "Richard Quintin" <quintinr@...> Hi, 'Accept' is a...
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: "Gary Turnbull" <turnbulg@...> Colin, If you are using...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
