Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MikeJones
  • Content: Threads
  • Order by date
  1. MikeJones

    Need a Good Book for Designer / Dev 2K on ORA 9.2

    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...
  2. MikeJones

    URGENT Help on large duplication removal

    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...
  3. MikeJones

    Finding the first day of the current week

    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.
  4. MikeJones

    Script to give me create constraint syntax

    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.
  5. MikeJones

    Enable novalidate Unique constraint

    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...
  6. MikeJones

    Setting the default Mail Client in Outlook??

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

    LOB's and CHUNK and PCTVERSION

    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...
  8. MikeJones

    After some code to convert from 8bits to 6bits to 8bits

    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...
  9. MikeJones

    VERY slow sorts

    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...
  10. MikeJones

    DBA Help needed!!

    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...
  11. MikeJones

    Adding union alters explain plan drastically

    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...
  12. MikeJones

    I have two queries that run very fa

    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...
  13. MikeJones

    PLS-00417: unable to resolve "COLUMN_NAME" as a column

    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...
  14. MikeJones

    Migrating LONGs to LOBs

    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...
  15. MikeJones

    UUEncoding - Urgent

    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.
  16. MikeJones

    Outer Join Problem (I think!)

    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...
  17. MikeJones

    ORA 4030out of process memory when trying to allocate x bytes

    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...
  18. MikeJones

    Nested tables

    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...
  19. MikeJones

    Perfomance problems of Inline Views

    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...
  20. MikeJones

    Need a command like preat on AIX

    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?

Part and Inventory Search

Back
Top