30/09/2018 11:47
Hi. I have a server A with oracle 10g express (free) and a serverB with an Access database.
I need that an application that uses oracle server can reads tables onB. How can i do this?Can do i make a Local View on A of B?thanks

5 answersclick here to view

29/09/2018 11:47
We need to identify the SQL query a process is executing that'screating a lock contention; how do we do that? For example, with MSSone can do 'DBCC INPUTBUFFER(spid)' tia -t

7 answersclick here to view

28/09/2018 11:47
I have a table that collects the scores of players called results.
e.g.
Bob 45,Jon 55,Tom 34,Tom 44,Bob 70,Tom 54,etc Each player can have as many scores listed as they like. What I wouldlike is to simply produce the top three sum per player and order bythat sum. Loosely speaking what I want is the following query...
SELECT name, topThreeSumFROM resultsGROUP BY nameORDER BY topThreeSum DESC I posted a similar question a couple months back and Strawberry(thanks by the way) gave me some code to.... read more

5 answersclick here to view

27/09/2018 11:47
This is more a general SQL question than an oracle-specific question,but if there's a nice Oracle-specific answer, I'll take it.
I have a table, call it: CREATE TABLE ROOMS_TO_CLEAN ( BUILDING_ID NUMBER NOT NULL, FLOOR_ID NUMBER NOT NULL, ROOM_ID NUMBER NOT NULL, PRIMARY KEY (BUILDING_ID, FLOOR_ID, ROOM_ID)); We'll call a 3-tuple in this table a dirty room.
Now, because this is a made up example, trust me that it is completelyunfeasible to have a single master list o.... read more

2 answersclick here to view

26/09/2018 11:47
What's involved in distributing mySQL as part of a shareware downloadas part of an application?

5 answersclick here to view

25/09/2018 11:47
RANT MODE ONLast couple of weeks I've been trying to put together an architecture for anew highly available production internet web services and database W2K is the platform so 10G AS not available.
Great I thought I can use Oracle Maximum Availability papers I did - oh boy are there holes. Check MAA for details on IAS infrastruc HA -you won't find many.
The database - yes - completely solid - these are technologies - RAC,DataGuard and Standby etc etc - great no problem I can live wit.... read more

3 answersclick here to view

24/09/2018 11:47
Hi,It is Oracle 9i/HP-UX.
Network has sufficient bandwith OC3 155Mbits /sec ( WAN though ).
Required throughput is 30Mbits/sec.
log_archive_max_processes 10log_archive_dest_2 SERVICE=ERPST lgwr async=20480 reopen=15max_failure=10 optional net_timeout=30 Any ideas ? Regards, Ranko.

3 answersclick here to view

23/09/2018 11:47
Hello, I'm currently developing a JDBC program on Oracle and I have thefollowing problem.
I use the BLOB.getBinaryStream() method, it works fine, I got thestream and I can read it.
My problem is slow performances, when I call stream.read(): The first call takes 10 seconds.
Then 32*1024 next calls are very fast.
Then hang for 10 secondsThen 32ko readed fast, hang....
Do you have any idea if this is Database or JDBC problem? The network is fine.
I think it's a SQL Net problem, because.... read more

5 answersclick here to view

22/09/2018 11:47
Does anyone know how to instruct SQL*Loader to ignore the last recordin a flat file when the size of the flat file is not constant?

1 answersclick here to view

21/09/2018 11:47
hello DBAs, I think latch is private memory taken in SGA by each user while workingon database. Is it Correct.
AndAs Soon as I tried to connect to my database by any user on network, itis taking much time whereas my network and database are workingproperly. What can be the problem here, because after connection thereis no problem in performance.Pls help......
Thank You

4 answersclick here to view

20/09/2018 11:47
Hi, I would like to store perl scripts in tables in mysql. So that whensomeone clicks on a button on a web page, it will run the query onthat button to remove nodes in and out of the load balancers which isa perl script. This perl script telnets into the appliance. Willsomeone provide a command or keyword so that I can searchdev.mysql.com. The perl scripts has sensitive username/ passwords sothat by storing it in tables, will make it less hackable. Thanks inadvance.

7 answersclick here to view

19/09/2018 11:47
When backing up data from large RAM to small RAM (RAM backup ), ORACLEfailed to work with message 'database unavailable'.
Appreciate your help!

1 answersclick here to view

18/09/2018 11:47
Hi there, I have an obscure problem.
I moved my oracle instance (8.1.7) from one subnet to another (changedon server tnsnames.ora, listener.ora, tnsnames on clients) and now onlya few seconds after startup, sqlplus and other clients can connect.
After some seconds, I get errors on client side, but tnsping reports noerrors.
The error messages are : client: ORA-12545: Connect failed because target host or object does not exist sqlnet.log (client): *************************************************.... read more

2 answersclick here to view

16/09/2018 11:47
Hello, I've created a query that returns rows sorted by date. From the newestto the oldest.
I need to get the first element, that is the newest, and then the restof the elements but in reverse order, that is the oldest to thenewest ie.: id, name, date----------------------12 item4 2010-12-2516 item34 2005-11-5123 item2 2001-10-1591 item925 1996-8-882 item7 1992-3-12145 item445 1989-10-6283 item8 1985-5-1675 item53 1978-2-4345 item12 1976-7-772 item91 1963-5-17 output shoul.... read more

5 answersclick here to view

15/09/2018 11:47
Hi,I am planning to install Oracle 9i/10g on Sun Solaris. Below are theactivities I need to do. Can some body provide me Step-by-Stepprocedure to be followed for below activities.
Pre-Installation ActivitiesCreating a install UserConfiguring OS Memory and shared memoriesCreating distinct file systems for Oracle -- Capacity planningInstalling the productPost product installations Thanks in AdvanceSampath

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