12/12/2018 11:47
I have a table defined like: CREATE TABLE ORGS(NUM INTEGER NOT NULL,ID INTEGER NOT NULL) In the table I have like: num id41 541 641 799 589 9 I was wondering if there is a method where I can generate a resultdataset from a sql query that looks like: 41 5,6,799 589 9 My approach currently is to iterate over the result dataset to producethis.
Mike

10 answersclick here to view

11/12/2018 11:47
HelloI've installed oracle-instantclient, oracle-skd and oracle-sqlplus.
everything works fine, except tnsnames...
a can connect to remote database using: sqlplusxx/xx@(description=(address=(host=10.3.1.159)(protocol=tcp)(port=1521))(connect_data=(sid=DVLPBIS))) but I'm not able to use tnsnames.
I've created (ok - used my windows tnsnames) TNSNAMES.ORA as below: DVLPBIS=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.3.1.159)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=DVLPB.... read more

2 answersclick here to view

10/12/2018 11:47
HP Unix 11.0Oracle 8.1.7.4I have a procedure which runs OK sometimes and errs out at othertimes with an ORA-1843. This would have been expected to failconsistently if there was a date mismatch not only occasionally .Theprocedure was created with no errors.
The procedure in question is called via a shell script (if that helpsany) Your input will be greatly appreciated? TY if the code will be of any help the heart of the code is here select (sysdate-to_date(t.start_time,'MM/DD/YY:HH24:M.... read more

1 answersclick here to view

09/12/2018 11:47
BRAND NEW SERVER FOR SALE NEVER USED IN BOX 1 Compaq ML570 server dual xeon 700 processors ( canhandle 4) IntelĀ® PentiumĀ® III XeonTProcessor 700MHz/2M1GB Total ECC SDRAM PC 100MHz (4X256) IncludedStandard Two 6x1 Drive Cages (Holds Up to 12 1 Hard Drives)Integrated Dual Wide-Ultra2 Controller - IncludedNo RAID setting18.2GB Pluggable Ultra3 SCSI 10,000 rpm Hard Drive (1)1.44MB Floppy Disk Drive - IncludedHigh Speed IDE CD ROM Drive - IncludedNC3123 Fast Ethernet 10/100 WOL.... read more

3 answersclick here to view

08/12/2018 11:47
Hi, all - I recently had to figure out how to transfer a 13GB export betweenboxes. The customary way is to split and compress but I didn't wantto do that for reasons irrelevant to this posting. I came up with atechnique to tunnel the export stream between servers. It was createdon Unix, but can be used in the Windows world if you get the M$version of the utilities installed. Here we go: Assumptions: SOURCE = machine we are exporting fromTARGET = machine we are importing to Prereqs: * .... read more

2 answersclick here to view

07/12/2018 11:47
I am using 2 tables: an Order Header and Order Detail. The problem thatI keep running into is for a request to pull some criteria based on thedetail lines, then display all the lines for orders meeting thatcriteria.
So I believe that the SQL is first executing to get all the line(s)that meet the criteria. Then it is going back through the table togather the header and all detail lines that meet the previous criteria.
This results in multiple table scans.
Is this the correct way to do this? Is .... read more

5 answersclick here to view

06/12/2018 11:47
Hi all, I need to move a bunch of indexes from one tablespace to another duringan upgrade. I'm assuming that I just ALTER INDEX, specifying the targettablespace. Some questions: 1) I know it's possible to run the rebuild while connected as the userwho owns the tables, or as SYSTEM or SYS. Is any one of theseconsidered to be best practice? 2) I notice that Oracle has automatically added indexes with namesbeginning SYS_IL0000 for the tables that have BLOB columns. Can Isafely rebuild thes.... read more

1 answersclick here to view

05/12/2018 11:47
I need to move a datafile from one disk to another. I am runningOracle 9.2.0.4 on HP-UX11. I have done it before one a test systemwhere I could control the access. We run SAP and in the test systemI could make sure there were no users BUT SAP was still up. Thedatafile move went uneventful. Now I need to do it to a production. What exactly happens if someoneor something tries to access a table that is OFFLINE? This datafilemove shouldn't take too long BUT I can't get 100% of the use.... read more

1 answersclick here to view

04/12/2018 11:47
i have the following table structure with sample data TranxID RowID Table Description NewValueOldValue1000 1 Table1 IDX 11000 1 Table1 MAPPING AB1000 2 Table1 IDX 21000 2 Table1 MAPPING XY1000 1 Table2 IDX 11000 1 Table2 MAPPING CD2000 1 Table.... read more

3 answersclick here to view

03/12/2018 11:47
Hello there, I was wondering if anyone was aware of any application that can track mySQL database schema changes.
Here is what im trying to achieve;We have a database that is poorly designed, I shall call this the 'Start' databaseI want to make a whole bunch of changes to the schema that once done I shall call the 'End' databaseI then want to develop the application according to the 'End' databases schemaOnce the applocation is ready I then want to execute a script that .... read more

3 answersclick here to view

02/12/2018 11:47
I keep getting 'too many connections' errors.
When I 'SHOW PROCESS LIST' I get an endless list of these: | 2974081 | unauthenticated user | xxx.xxx.xxx.xxx:36048 | NULL |Connect | | login | NULL| ||| The xxx.xxx.xxx.xxx is always one of the 4 other servers that connect tothis one, the 'unauthenticated user' connections are fairly evenlydistributed over the 4 servers.
I have no idea why this is happening.
If I ssh into one of those 4 servers and try to connect.... read more

10 answersclick here to view

01/12/2018 11:47
I've written a few notes on an implementation of a tree in mysql: http://www.dustbite.se/tree/ I've used the same set of data as: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html.
and discuss how the queries from this article can be constructed in thismodel. Feedback, anyone? /Lennart

4 answersclick here to view

29/11/2018 11:47
Hi All, It is my understanding that UNDO works differently in 9.2 and 10.2.
Size of undo datafiles is fixed, AUTOEXTEND is OFF.
9.2: Oracle will maintain undo blocks according to UNDO_RETENTION.
If UNDO tablespace is large and UNDO_RETENTION * undo bloc generationis low then the tablespace will be almost empty.
If UNDO tablespace is small and UNDO_RETENTION * undo block generationexceeds tablespace size then UNDO tablespace will run out of space.
This will cause transactions to fail with ORA-30.... read more

1 answersclick here to view

28/11/2018 11:47
Hi all, I was reading the Concepts manual and it says from 9i you have theoption of both native and interpreted execution available for storingPL/SQL program units.
Why should we even have to consider interpreted execution when thereis a native (object code) version available? Wouldnt the native versionbe faster? Thanks.

3 answersclick here to view

27/11/2018 11:47
Hi AllWe have decided on the following setup for our database server Oracle 9i + RACRedhat linux (AS)Netapp filer (for shared storage).
Any ideassuggestions??go for 64bit cpu??btw,cost effectiveness is NOT a major fector-we look for 1.reliability2.performance.
Thanks Yossi Ben Haroosh System Administrator http://www.netwarkit.info

6 answersclick here to view

eDiscover
Helpforce eDiscover provides technical articles updated each day
Click the logo to go back to the main page
Databases

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.

Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS