We just got a request from our DB group to increase ramfs on RHE4 linux, running oracle 10g. One of our DBA's recommended installing hugemem kernel. We installed and followed the steps from ...
We have an Oracle 10g db on win 2003 server with a database link to an Oracle 10g db on Solaris 10.
We have a view on the win2003 server selecting from a table on Solaris 10 via database link...
Oracle 10.0.2.0.3 in WIn 2k3 Enterprise. I recieved an email from the server, yet the server is up and running, the alert is clean, listener.ora have no TNS errors, this is MTS mode:
Name=...
I created a new database.
I received a dump file from another database (I do not know what all users were present in the original database) and would like to get everything, users, table de...
Here's the Oracle package . . .
f_costAtCompl(as_jobId, as_costTypeCd, as_cc {, adt_endDate, adt_maxCreationDate})
I want to know the syntax of the SQL line to execute this package with ...
I have three schemas A, B, and C with all the exact same tables. The only difference is they resided on different databases in remote locations. We moved the loading of the data for all t...
Hi,
I am trying to do an update query in SQL (oracle 10g)
the table i want to update is of the form;
"FOR_DATE" DATE NOT NULL ENABLE,
"SITE" VARCHAR2(100 BYTE),
"OUC" VARCHAR...
I created two database links newlink and newlink1
create database link newlink connect to arnold identified by arnold using 'ext';
database link created;
commit;
same thing for
create da...
i have to query two tables .oner table has XML Data ,le table has regular data ..i need to do query using two table like foloowing but it is giving me invalid identifier error for oner table.....
Management like to know what was the database size an year ago.
Is there a way a DBA can able to find the size of his database which was about a year ago.
If not exact but approximate si...
I work on an appliction which queries multiple databases for data and consolidates this data into a single database for reporting purposes. The application works by installing it on a server a...
Hello Experts,
I have a 10gR2 database running on Sun Solaris OS; the database is in archive log mode. Now i want to create same exact copy of this database on my Windows Box. Other than usin...
We are using Oracle database 10g Enterpise Edition Release 10.2.0.1.0.
I have the following query and gets result in cost as 12539
TMDM@TMDM.REGRESS.RD> EXPLAIN PLAN FOR
2 SELECT * FR...
hi,
I want to automatically store the scanned copy of a PDF document to my oracle database. I think i have a little bit knowledge of integrating the scanner with the database application. I...
I was running Oracle 10g when my PC crashed. I have reinstalled Windows XP on C Drive. My Oracle installation, DBF files, CTL files are all intact in Drive D. Now I want to reinstall Oracle & ...
Hi all,
I implemented all the segment advisor recommendations but the warning icon is still visible showing 23 recommendations.
How can I clear the Segment Advisor Recommendations displayed ...
We have 365 Partitioned Table in OLTP environment, but keeping 3days worth of data (3 Partitions only). Data is Real-Time and non reproduceble. After 4th day we truncating 1st day partition.
...
I have 2 machines that I have installed on both Oracle Express 10.2.0.
Machine "A" is a development machine and Machine "B" is the production machine. I want to take the whole database from M...
I am trying to perform a self referential join in SQL (on Oracle but any ANSI compliant code will do).
I want the "superssn" foreign key in the employee table to reference the "ssn" primary k...
Dear experts,
I followed the steps in this tutorial on deploying .NET stored procedure:
http://www.oracle.com/technology/pub/articles/mastering_dotnet_oracle/williams_sps.html
I h...
Please let know how i can update data in the tables present in Oracle using Sql stored procedure.I have to update certain data present in sql to oracle database and vice versa. Can we use orac...
I installed oracle 10.2.0.1.0
I am working on oem..how can I work with grid computing?
dear experts -
I want to parse the string extract the contents. here is the situation
String : 'ABC - 12345 THRU ABC -56789'
Out put should be
12345 ON ONE COLUMN
56789 IS ON A...
Hi,
I have a question regarding loading external information (i.e. from a file for instance) into a table in an Oracle database.
I'm familiar with Sybase and SQL Server with doing a BCP...
hi
i have 2 oracle instances with the same name(one is on the old server and the other is on new server.)
when i login for both and i run this
select instance_name from v$instance
i see bo...
