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...
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: ...
How can I delete the archive logs if i have tow instances on cluster?
both instance are on no archive log mode
Thanks
Hi all,
Can anyone recommend on a Source-control/Version-control tool they have experience with?
We are currently using TOAD's team-coding, integrated with Microsoft VSS, but only since ...
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...
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...
Hello,
I have recently started looking at flashback technology in Oracle 10g. However I need some clarification.
If I run the following command ...
SQL> select flashback_on from v$dat...
my table aand column are already created. can i now modify the table to include a default value for a column?
We're looking at implementing Dataguard as part of an implementation of Documentum (a document management system from EMC) and I have been asked to look at producing documentation and scripts ...
We are using Oracle 10G 10.1.0 database. Sometimes listener is stoping answer connections. Because of Pooling applications running without any problem. But we couldn't make new connections. By...
My database runs slowly , i check Library cache :
SQL Area : request : 71040
miss: 51653
--> 70 % miss
index : request : 1451
miss:575
--> 40% miss
...
C:\oraclexe\app\oracle\product\10.2.0\server\BIN>net start OracleXETNSListener
System error 5 has occurred.
Access is denied.
C:\oraclexe\app\oracle\product\10.2.0\server\BIN>net star...
I need to be able to export specific tables from a particular schema using my exp command line utility
The schema name is 'DELTEK'
and the tables need to start with EMPL and USER.
Thanks...
I'm trying to add a Command to my report in Crystal Reports XI through the Database Expert interface. I have successfully been able to do this with my current report using my Oracle 10 databa...
Hi, I need to find the query response time in Oracle, MySQL and MSAccess that is:
time to parse
time to execute
time to first
time to last
Well when I set timing on in Oracle it returns t...
I have a SQL query which returns results and places the results in an XML file. the problem is that one of the fields can contain ampersands (&) in the field, so when a bare & is put into an ...
I wanted to move our database from Windows 32-bit to AIX 64-bit, both running Oracle 10.2.0.4.0 using transportable tablespaces method and expdp/impdp tools. I did everything I suppose to (we ...
Hi,
I have the following query;
select qid,
sum(decode(mcanswer, 0, 1,0)) mczero,
sum(decode(mcanswer, 1, 1,0)) mcone,
sum(decode(mcanswer, 2, 1,0)) mctwo,
...
Hi, guys,
I need to transfer data from Microsoft Access 2003 into Oracle 10g standard. I know it coud be done if I save data as .CSV file. What to do next?
folks
how do i show the first day of the week in dateform of a certain week ie
week 25 will show 15-6-2008
all help will do
I am running Citrix Presentation Server 4.5 Advanced Edition on a Windows Server 2003 Standard SP1 along with Citrix Access Gateway 4.5 Standard. We have published applications running on Orac...
