Is there a way to disable this udump trc files?. I am using oracle 10g and i have set the following in init.ora
sql_trace=false
trace_enabled=false
oracle_trace_enable=FALSE
But still ...
what is the difference between oracle 10g server and oracle 10g client?
Hi all. I have a materialized view that gets data from another database. Is there a way to change the datatype of the materialized view to Varchar2 with trim. Greatly appreciated. Below is the...
I am new to Oracle and have a restore question:
I have a new Oracle install on my server and I would like to restore a backup from the backupsets folder. Unfortunately I do not have the db...
I have multiple "producer" (java application) that is producing jobs for multiple consumers (also java application).
I am thinking of using an Oracle database table to act as a job queue. S...
Windows 2003 server with 3 intances of Oracle - 2 running in Oracle 10.1.0.3.0, 1 running in 10.2.0.2.0.
One of the databases (DB1) running in 10.1.0.3.0 is producing vast quantities of error...
i have 2 oracle databases on an HP platform.One database is called testdb1and the other is called testdb2
all the objects in testdb2 are owned by testdb1.
When i log on to testdb2 using ...
I run a printing shop, I get a new file is created on DMP from Oracle, but for me be able to print the file I need to convert to AFP. Does any want knows a solution to be able to conver this ...
Currently running Oracle 10g R2 on Red Hat Enterprise Linux 4. Am in process of cleaning up security. For unknown reasons, multiple table owners within several Oracle Sids were granted the D...
I executed a script to delete a tablespace and associated users from an Oracle database.
However, although the tablespace has beeen dropped, the user sessions still remain. The user is sti...
I have the following data
john | apple
john | melon
john | grape
jane | orange
jane | apple
mike | mango
I want to create a VIEW that has 2 new columns, c and d where c is the seque...
Problems with Oracle 10g on Linux.
Hi, we have a server on which the DB crashed. We have restored a backup which now has a different SID.
When trying to access the restored DB we get the...
Dear all experts,
My boss give a task for review of all tables in database and perform housekeeping to clear up all out-dated data\table\object. However, our databases do not enable auditin...
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...
I currently have the following query:
SELECT Max(o.Off_Date), Min(o.Off_Date), o.Off_Date, ob.OB_JOB_NUMBER
FROM Offence o, Offence_Batch ob
WHERE o.fk_off_ob_id = ob.PK_OB_ID
AND Trunc(...
I have two schemaâÃÂÃÂs and want to copy some of the tables and the data in the tables from schema A to schema B and but when I take over the tables I want to change the tablespace and ...
Hi,
Does anyone have experience in setting up Oracle 10g using Automatic Storage management (ASM) on Solaris 10, using ZFS?
I would appreciate some pointers / instructions..
thanks
I want to know if there is a sys table or view record the information like last DML apply to a particular table in Oracle 10g. Thanks.
We have both #Vb6 and VB.NET applications , we need to store and retrieve Chinese characters.
The .NET applications work fine.
On the same databse though , whilst the GUI controls work...
hi,
I am installing oracle 10.2g with OS Linux 4 on VMware 5. while installation to use xhost I have setup display as below :
DISPLAY=test:1.0
export DISPLAY
After this when i start i...
hi Experts
I have installed Oracle Database 10g rel 2.0 after that i want to Login to this URL
http://localhost:5500/em
i get this Error :
ORA-00604: error occurred as recursive SQL level...
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...
Hi, everybody.
Oracle Database Control 10g (MS Window Server 2003) displays on the home page the following message
-- java.lang.Exception: IOException is sending Request :: Connection ref...
I am setting up a new 10g db and have created the oracle users. I imported each users objects one by one from a full 9i export. I want to repeat with up to date data from the live 9i db. Shoul...
I would like to increase the size of my REDO logs from 100MB to 500MB. We have a job that runs every Sunday night, and it is filling up the 3 100MB logs causing new user connections to be reje...
