How do you obtain the Oracle_SID, listerners.ora and tnsnames.ora of a database?
I want to install and configure Oracle Discoverer in a three tier structure, WebServer, App Server and DB Server in a Windows 2003 (64Bit) environment. The Database Oracle 10.2.0.3 is alreay...
I have a SQL script contains DMLs
***************************************************************
insert into table t1
(C1,C2,C3,C4......C10) select C1,C2,C3,C4......C10 from x1;
insert...
I upgrade my database to 10g. My statspack stop working! I did delete the perstat user all its objects to I can start clean statspack config. so I rin @?\RDBMS\ADMIN\SPCREATE.SQL and prom...
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,
...
I need to transcribe this query from SQL Server 2005 to Oracle 10g.
CREATE VIEW CLAIMS AS SELECT QC.*,
ISNULL(P.PROVIDER_NAME, CASE WHEN QC.PROVIDER_ID IS NULL THEN PU.PROVIDER_N...
I have newly installed Oracle application express.
Works great with the local Oracle XE database.
Now I would like to use it to remotely login to another database.
Using sqlplus, the c...
Hello,
I am looking for a way to defrag an Oracle datafile volume reside on a clustered disk drive (HP MSA500G2) online.
I tried the regular Windows defrag that caused seviere problems on th...
can i downgrade a database from 10g to 9i? Or, can i export a 10g database either using 10g export binary, or 9i export binary, and then import into a 9i database?
I need to be able to have a standby database autostart and mount as a standby instance.
Right now the service autostarts and i have a script/util connect and mount the idle instance after t...
I'm having an Open Cursor issue with Java web app calling an Oracle 10g database. Here is the Open Cursor SQL.
SELECT NULL AS table_cat, t.owner AS
It being created by
DatabaseM...
Hello,
This is going to be a really dumb question but I'd like you to just look at it a bit more objectively than you normally would. It deals with standard RMAN backups.
We perform RMA...
I am running oracle 10g on windows server 2003. My listener.log file is over 2gb's now...can I delete text from that file without damaging anything? Is there a better way to go about it than...
I need to setup something like SQL server log shipping for my Oracle 10g database. I have the PRODUCTION oracle server hosted at a co-location. We have a secondary server at HQ with an oracle ...
I'm unable to connect to Oracle 10g database on a remote UNIX server via SQL*Plus Worksheet. I receive "ORA-12154 TNS:could not resolve connect descriptor specified." I can connect via OEM (9i...
Hi,
I've tried applying the 10.2.0.3 patch to an existing installation of Oracle Express Edition. But Oracle universal installer does not seem to recognize the oracle home directory.
Alter...
Hi all,
Though i am working in Oracle for sometime but i am new to this administration part.
We have Oracle 10g installed in one system, we are planning to move it to a new system(same p...
I'm new to developing SQL for an Oracle Database and I need assistance with the following statement: I don't understand why I get an invalid identifer message for a valid column name.
UPDA...
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...
Is there anyway to auto format column width in Oracle SQL*Plus? I'm running some queries and they are not fitting on screen completely, getting truncated. What's the proper way to see all da...
hai
i am facing one problem to set oracle home to existing $PATH. I am doing like this
export PATH=$PATH:/opt/mis/oracle/product/10.2.0
my actual $PATH VALUE IS
echo $PATH
/usr/c...
HI,
I have a file of this following format
H Client POL start_date 11112008 end_date 04112008 run_date 04042008
A pal 100 2000 dsds 343434
A na 345 4534 gfg 344545
The first recor...
hi all,
I have 1 textbox in Oracle form, with format ##0.00 => means that we can input 33.33
But now, I want to input to this textbox value like 33.3333333333333333334
pls help me defin...
Hi all!
I would like to know if there is any software which can measure step by step the time that takes to execute a query on an Oracle database. Also if it can do a load test simulating f...
Hello,
I wanted to execute couple of queries as transaction in oracle 10g.
I'm executing these queries from .net application. So I will be sending these queries not at once. Typically, be...
