I have attached a complex query and its execution plan. The query acts on the linked results of a document search. The SQL collects all the stored meta-data across all affected tables. I am ...
Working with connection pooling, and I just wanted to get confirmation that my assumptions are correct.
Connection pooling does not work across client applications, even if they use identical...
Dear Experts,
I have successfully replicated data of a single table from Oracle 9i to Oracle 10g. I set the materialized view to "updatable" (see the reason below).
Question: Is it p...
I want to load almost 100K of data into a Global Temporary Table in less then a second, I would like to know the fatest way to do it with some examples. I will appreciate all your help.
The date format in Oracle seems to be accepting dates such as "12-31-99999" with 5 9's. and so on and so forth. How can we set up constraints such that it won't accept such invalid dates?
why would i want to use a SPfile (server parameter file) instead of the ora.init file , will it allow me to change parameter on the fly with out restarting the instance ?
Dear Experts,
I have installed Oracle 10G IAS, where I have 5M records, and I have configured the Gather_Stats_Job to run in the default maintenance window, however I have been advice...
O.k.
I understand that data and timestamps both are stored as numbers in the underlaying Oracle database.
My application requires returning the number of seconds since Julian start of time.
...
We a trying to upgrade our vendor provided and somewhat supported Oracle environment from 10g R1 to 10g R2 and can't get a straight answer from them as to what we need to do to make sure we ar...
What is the preferred method to shrink a table that contains a LONG Datatype? I can not change the data type due to the third party software application. I need to find a way to shrink these...
Below is the insert statement contained in the procedure which works when run in SQL Plus (I had to use a fixed po_item_id to test it)... I have also included the trigger, procedure and sql s...
Hi Experts ..
I am writing c# application/ADO.NET to read data from Oracle DataBase. I have a stored procedure with cursor as OUT parameter, and I want to know if it is possible to r...
Hi Experts ..
I have a comma seperated string (1, 2, 3, 445, 2213), and I want to write a function to seperate it.
In the following snippet, it is part of Oracle pacakge, I just w...
I have just installed oracle 10g.
We are currently on oracle 8i. Oracle 8i is on a seperate machines.
Just for testing I wanted to try the oracle upgrade engine.
On our Oracle 10g databa...
Use DBMS_STATS to anaylze indexes for 200 tables in a schema?
I have 200 tables that I need to analyze stats on after altering the tables to add indexes.
Should I use DBMS_STATS or is t...
How can I delete the archive logs if i have tow instances on cluster?
both instance are on no archive log mode
Thanks
Hi, Experts
I am new to oracle, the following T-SQL statement works well on SQL but not working with oracle, there is something wrong with last sentence ORDER BY A.ParentId, A.ModuleOrder
ca...
folks
how do I show the first day of the week in week 23?
r
I have Oracle 10g Express installed on Windows XP. Out of the box, Oracle 10g Express creates a database called XE. My Java code wants to use the database corpdb. The JDBC connection strings l...
folks
can i create a dblink between oracle 9 and oracle 10
can anyone help me with an example , my oracle 9 server is called (77.11.2.33) with db TEST
and oracle 10 (76.12.33.44) with d...
Our database is running and have error and i check the alert log :
"~ORA-16038: log 5 sequence# 5160 cannot be archived~ORA-19504: failed to create file ""~ORA-00312: online log 5 thread 1: ...
hi,
i have to migrate an sql server database to oracle, there're many tables with columns of timestamp data type in the sql server database, now how can i simulate this column's functionality...
Hello,
What is the meaning of below. How to interpret it and convert in MB/GB.
SQL> show sga;
Total System Global Area 1.0855E+10 bytes
Fixed Size 2089216 bytes
Var...
Sir ,
I was trying to create database manually in oracle 10g
I created instance set oracle_sid=new
I created instance..
everthing is fine....
In
startup nomount
Oracle instance sta...
I would like to use Enterprise Manager to create a job that executes a script to delete old backups. The script has already been created. Is it possible to schedule this script to be executed ...
