Search results for query: *

Hi everyone. I (like many others) used to frequent "Ask Tom" for much useful insight and assistance with all things oracle. The site has hitherto been nigh on unbeatable for evidence-based clear answers to sometimes murky questions. However, Tom hasn't answered a question for over three months...

I am using 11g Release 11.2.0.1.0 - 64bit Production and am logged in as SYS as SYSDBA. I am attempting to extract the DDL for tables in several schemas. Each schema name begins with 'JOB_' and I am using this as a filtering condition. The following sql SELECT...

I am trying to ascertain whether or not there is a jdbc driver which is compatible with DRCP. I am at the start of a project, and want to use DRCP to give the application server a pool of connections that all appear to be direct, thereby enabling the application to log in as a particular user...

Folks, since so many of you obviously enjoy these puzzles, how about teaming up to tackle some of the project Euler problems? Although the answers are already known (otherwise how were the puzzles set in the first place?) it might prove beneficial for us all to learn from one another about the...

I am processing some DML produced by an automatic tool. Unfortunately, some of the data contained carriage return and line feed characters, which caused the data to be spread across several rows. I need to joing them back together, to make valid insert statements. Sample data is:- CREATE...

I am currently "doing battle" with a developer who sees no need to close cursors, once used. I have googled and found the following article http://www.gennick.com/open_cursors.html by the illustrious Mr Gennick. He cites conversation with Messrs. Feuerstein and Llewellyn w.r.t. closing...

I am a senior Oracle DBA, who has hit the glass ceiling. I can't progress any further, as I am already paid at or near top dollar for my job. I have the right experience and ability to do design and technical architect work, but am in the old problem, no job no experience, no experience no...

I'm wondering about the legal and ethical implications of something:- A couple of years ago, I wrote (in my own time and at my own instigation) a piece of software which made my work life vastly easier. My boss was overjoyed when I presented him with it, and immediately appreciated the...

I have noticed a quirk in the primary key creation of tables. DROP TABLE PK_TEST CREATE TABLE PK_TEST (DUMMY_COLUMN VARCHAR(100)) ALTER TABLE PK_TEST ADD CONSTRAINT NN_PK_TEST_DUMMY_COLUMN CHECK (DUMMY_COLUMN IS NOT NULL) ALTER TABLE PK_TEST ADD CONSTRAINT PK_PK_TEST PRIMARY...

Monrow, I hope you find this forum useful. As promised I have a solution for you below. Run the script below to build and populate a table with sample data. CREATE TABLE MONROW ( A VARCHAR2(5), B SMALLINT, C VARCHAR2(100) ); INSERT INTO MONROW VALUES ('code1',1,'ZE'); INSERT INTO...

I have a select statement which returns a variable number of rows. I have included it in a user-defined table function, and it works ok. What I want to do is number each returned record consecutively, in a manner similar to Oracle's rownum function. From various searches I understand that...

I am using 2000, and have created a linked server connection from sql server to oracle 10g2 and can execute stored procedures using the OPENQUERY method, and get results back. However, I want to execute a stored procedure which returns no records. Having searched via google (and within Tek...

I have a problem with regexp, and am looking for suggestions. The requirement is to examine a string, which is of unknown length, and contains new line characters, which are interspersed with desired data. Wherever a line starts with [ABODS] it is required to detect the data thereafter, which...

I am trying to detect the use of OMF and ASM within a PL/SQL procedure, i.e. I want to create two functions called ASM_IS_BEING_USED and OMF_IS_BEING_USED which return booleans, indicating whether or not the instance involved is using ASM and OMF respectively. The Oracle ASM doco...

Folks, I can't seem to set FAST=TRUE in my production system which is very slow. What should I do? Regards T Grinding away at things Oracular

I am trying to find information about the impdp utility, as I wish to deliberately import in conventional mode, as opposed to the faster direct path. I have read the documentation (http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#i1021478 refers) and although it...

Folks, My problem is this:- I have a db in a known guaranteed condition, with known and guaranteed data. By means of known, controlled scripts, data will be added to this database. What I want to do is find a systematic method of distinguishing between the data in the db before the scripted...

Folks, A recent post answered by one SantaMufasa has finally pushed me over the edge. There seems to be no limit to what we're expected to be able to answer, based on the vaguest of unclear statements. Can we agree and create a FAQ on "how to post"? As a starter, I suggest a model question...

There is a nasty bug in 10.2.0.1.0 sqlplus whereby previously fine 9i scripts abort with an error. If you use the CLEAR SCREEN command in a sqlplus file, and run it from sqlplusw, all is well. If however, you invoke exactly the same script via a batch file and call sqlplus, the clear screen...

folks, I am determined to learn PERL as my scripting language for Oracle (I am an Oracle DBA who's pig sick of struggling with decrepit tools). I have downloaded ActiveState perl, and can say "Hello World" etc. However, to be meaningful for me, I must be able to connect to an oracle database...