10/04/2018 11:47
I am on Oracle 9i with a HPUX platform and we are using Sql loader toload tables from flat files. With external tables now available tohandle this task, I was wondering which performs better. A directload with sqlldr or using the external table.
I am leaning towards the ET because it will eliminate the need for astaging table that we use on the sql loader method.

10 answersclick here to view

09/04/2018 11:47
Hi, We are planning an upgrade from 8.1.7 and 9.2.0 to 10gR2. There are fewdatabases on Windows NT and few on Solaris. And here are some of myapprehensions: 1. Is any characterset not supported on 10gR2?2. What is meant by 'encrypted objects'? Is it tough to upgrade them?3. By upgrading to 10gR2, are we talking about moving from 32-bit to64-bit or vice-versa? How will it impact the upgrade process? Thanks,Raghu

5 answersclick here to view

08/04/2018 11:47
Hi all.
I'm building a web app using Oracle 10g (NOT AS) and PL/SQL. It's fairlysimple: a few packages producing web forms and pages writing/reading datato/from my tables.
I'm trying now to figure out what are my options for managing authenticatedaccess to some of my procedures.
I'd like to use db authentication (Oracle username/password), but I've neverdone this before: I browsed the Internet and the docs but couldn't clear upmy mind.
My questions are: 1) can I do d.... read more

8 answersclick here to view

07/04/2018 11:47
hy, my system have a Database Oracle on a server Linux distro Susewith Oracle Entarprise Manager 10g I'm doing a little programm in Visual c++ that do a query on thedatabase from an other pc with windows in a network with the linux pc.
But i have a problem with the connection to the Db, infact when i openthe database i have this error on oracle Db: ORA-12505: TNS:listner does not currently know of SID given in connectdescriptor (DBD ERROR: OCI ServerAttach) and my software connect to datab.... read more

16 answersclick here to view

05/04/2018 11:47
Hi, all.
I have a database server which has a failover server.
There is suspicion that the failover server may have been omitted in acouple of instances when we applied patches to the production server.
We did not use OPatch to apply these patches.
Is there a way to confirm between the two servers which patches havebeen applied, so we can establish whether they are indeed out of sync? Thanks! DW

2 answersclick here to view

04/04/2018 11:47
We are planning to host data for 50 to 100 different companies on asingle server. Each company will have their own set of data, but exactsame table structure.
Consider these solutions below: 1. Single database for all companies (companyid on each table)2. Separated database for each company From experienced DBAs what is most appropriate recommendation that youcan give for these two solutions above in terms of : a) scalability (more servers)b) maintainability (easy to deploy upgrades and avoid.... read more

2 answersclick here to view

03/04/2018 11:47
I have an Oracle 9i table containing details of courses taken: CourseCode, StudentID, DateAttended, Grade0001, 1, 2011/04/18, 600001, 1, 2011/05/04, 800001, 2, 2011/02/08, 650002, 1, 2011/05/12, 750002, 2, 2011/05/12, 750002, 2, 2011/05/15, 950003, 1, 2011/03/22, 750003, 1, 2011/03/25, 950003, 2, 2011/11/02, 450003, 2, 2011/11/05, 90 A student can do a course more than once, so there can be more thanone record with the same CourseCode per student.
How do I select the record with the highest gr.... read more

3 answersclick here to view

02/04/2018 11:47
Is there such a thing as ordered tables in sql or a simple way to emulate it? i.e., the order in the table matters and one can insert into into the table w.r.t to this order? I suppose I can have a column that sorta simulates the order but the problem is that I don't see how I can simply insert a new row without having to modify all others. If I could simply use the inherent order of the table then it would be much easier but then I think inserting will be very hard. I suppose I could have .... read more

6 answersclick here to view

01/04/2018 11:47
Guys,I have 2 tables, table1 (id, val1, val2,val3) and table2 (id,val1_new), each with exactly the same number of rows (~200,000) andsame values in id columns. I want to update a part of table1 which hasval2=val3 (~ 300 rows), replace val1 of table1 with val1_new oftable2. Both tables have indices on id.
I use this query: update table1 a set a.val1 = (select val1_new from table2 b where a.id=b.id)where a.val2=b.val3; it runs in about 3 mins just to update 300 rows, while a query withthe same pu.... read more

4 answersclick here to view

31/03/2018 11:47
Oracle 9205 on Windows 2000 I am trying to setup a job in OEM and keep getting the VNI-4052: Invalid target or target type. According to the metalink, I shoulddelete the job, delete the node and rediscover it. I ahve tried thisnumerous times and cannot get it to work.
Any ideas?

1 answersclick here to view

30/03/2018 11:47
I apologize in advance if either one of these are known bugs/issues, Itried searching through the newsgroups prior to posting but couldn'tfind anything.
PROBLEM #1Below is a simple example to reproduce a problem I'm experiencing. Itworks fine on 9i but the pl/sql block at the end produces thefollowing output on an 8i box (even though the statement just previousto the block works fine when referencing that column).
ERROR at line 4: ORA-06550: line 4, column 9: PLS-00201: identifier '.... read more

1 answersclick here to view

29/03/2018 11:47
Dear Gurus , as far as i know and tested , when i issue a parallel select statement, oracle ,instead of looking at database buffer cache first, itdirectly requests the data from the disk system. And when it reads thedata , instead of putting it into db buffer cache ,it copies it intothe process pga. So there is no db buffer cache benefit if the sameparallel query runs several times since db buffer cache does notcontain any data related to this table.
If the above statement is false , pls correc.... read more

4 answersclick here to view

28/03/2018 11:47
I want to give read-only access to OEM (dbconsole)is it possible to set up such access?how should I setup an oracle account ?

5 answersclick here to view

27/03/2018 11:47
Is it possible to use some type of option in an update statement so that only a single row (arbitrarily chosen) will get updated in the event that there are two rows matching a where specification? For example, in the following, if table W1 contains two rows where QN = 2, then both are changed to the value 3. I just want 1 of them changed to 3 and it doesn't matter which.
Update W1 set QN = 2 where QN = 3Thanks

4 answersclick here to view

26/03/2018 11:47
I am running most of my databases at level on Solaris andWindows.
My question is how do you like ASMM? I am getting ready to test it and would like comments.
Subject: How To Use Automatic Shared Memory Management (ASMM) InOracle10g Doc ID: Note:295626.1 Type: BULLETIN

4 answersclick here to view

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

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationWe 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

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