Search results for query: *

All, So we have the latest Oracle designer / Dev 200K toolkit, we are using it to store and generate the applications Tables / indexes etc. scripts and the guy that looked after it has left with no handover. I need to get to grips with this side of it first, currently we have little other use...

Hi, I have a problem where I need to remove a large amount of duplicate records from a large table. There are around 300 - 400K duplicate records in the table. The table containts about twice that in terms of total records (800K) Not all records are duplicated and some are duplicated many...

Hi Everyone, I need to work out the date for the start of the current week, assuming that Monday is the first day, so If I ran the query today (19th) it would return today, but If I ran it yesterday (18th) it would return the 12th. How can I do this in SQL?? Cheers, Mike.

Does anyone have a script they wouldn't mind posting that given a table would produce the text necessary to create all the constraints on that table? Cheers, Mike.

Hi all, I'm tring to create a unique constraint in enable novalidate mode. Here is the problem I'm getting. I can create the constraint in disabled mode OK. alter table my_table add constraint constraint_name UNIQUE ( col1, col2, col3, col4, col5, col65 ) disable / This creates...

Can anyone tell me where and how I set the default mail client in Microsoft Outlook 2000. Thanks in advance, Mike.

Hi all, I'm a bit lost with the chunck and pctversion parameters of a LOB's storage clause, has anyone out had much experience with them? Chunk From what I can gather this is the amount of space oracle will dole out for manipulation of a LOB upto 32K, which as that's the maximum you can...

Hi all, I'm not really a Java programmer so can you all please go easy on me, I'm afraid I'm one of those hated Oracle developers... As part of Oracle 8i you can now imbed Java straight into the DB which is great as the native language that comes with Oracle is to say the least, DB orientated...

Hi all, I'm running a query that returns 41K rows. If I run it without a sort it takes 9 seconds, If i run it with a sort it takes 49 seconds. Now I now disk sorts are slow but I never knew them to be THAT slow. So I looked at the temporary tablespace in which I'll be doing all my sorts and...

Hi I have acouple of questions I need a DBA to provide an answer for, I'm not sure if this is bread and butter stuff or a little off the line.... The Environment here is 8.1.6. If you amend the PCTFREE and / or PCTUSED for a table with lots of data in it what happens? If you have a Table that...

Hi all, I have an SQL stetement that I have to union with another statement, I'm having trouble keeping the explain plan as I want it, it seems the cost based optomiser won't leave it alone! The query is below, with the plan statement. This is without the UNION, it's working quite nicely...

I have two queries that run very fast on their own (Milliseconds) however when I combine them with a UNION the performance nose dives. I can't think of anything obviuos, they reurn the same sort of data, and the query does parse OK, but it just takes for ever to return, also when I run the...

Hi all, I'm getting the following trying to compile a package: PLS-00417: unable to resolve "USE_LOCK_YN" as a column The statement is doing an update setting this value to N, The table belongs to the schema I am logged in as, as does the package I am trying to create. I've checked...

Hi everyone, I'm currently in the process of migrating all our LONG data to the appropriate LOB. This process is very slow though... This is the method I am using... Create a table of the tables PK + the correct LOB Insert all the data from the original table using TO_LOB on the LONG column...

Hi All, Does anyone have, or know of where I can hold of some code to UUEncode a string in Oracle 8.1.6? Cheers, Mike.

Hi All, I've got a cursor that looks a bit like this... cursor my_cursor (in_other_value varchar2); select * from a, b where a.foriegn_key = b.primary_key (+) and nvl(b.other_value(+),'^^' = nvl(nvl(in_other_value,b.other_value),'^^) I thought this would work but it doesn't, My problem is...

Hi everyone, I'm getting the following error on one of our test databases. declare * ERROR at line 1: ORA-04030: out of process memory when trying to allocate 8208 bytes (call heap,pl/sql vc2) Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning...

Hi all, Im thinking of using nested tables to solve a problem I have. However the nested table I have would need to hold 2 columns, one of which would need to be a CLOB. The basic structure would be this... My_table Col1 - Primary key Col2 - Some Info Col3 - Some more Info there would be...

Does anyone know of any perfomence problems you can have with inline views?? Is In trying to solve my rownum problem i'm having to nest several queries in inline views and each time I nest them a level deeper the query seems to slow down to quiete a degree (i.e. from 2 seconds to 21 seconds...

Hi, I used to use AIX and it had a lovely little command called preat which for the last 10 seconds would give you how much time each user process had had on the cpu. I'm now on Digital UNIX V4.0F which doesn't have a command called preat, is there one like it called something else?