Hello
A client of mine uses a bespoke piece of software, based on Oracle 10g, which generates output using Oracle Forms rwservlet.
The 10g PDFs are generated seemingly very slowly (perha...
We currently have one oracle home for each database instance as a company standard because it facilitates database upgrades and emc disk replication. Not all database instances are upgraded ...
I am interfacing to both SQL Server and Oracle through a thrid party database web service.
If I submit a SQL query such as "select * from employee", multiple rows are returned from both SQL...
We have recently upgraded our database from Oracle 9i to Oracle 10g. Now i am facing an issue with the a PRO*C .pc script which used to run properly in 9i but in 10g it gives me errors for the...
I have renamed my test/practice Oracle database, to the name of my production database. I also need to change the dbid of my test database to be same as the production database, so as not to ...
Please give me a quick guide what steps I need to configure Dataguard.
There is an existing database and I need to configure a new node as standby.
For instance:
What are my first steps...
Query A results _ this data set is coming from joining of 3 different tables
Account Opening Balance
123456 0.00
987654 15400.00
234567 20000.00
Query B results - this data set i...
Hi,
I recently moved a C# web service from a dev machine to a production machine. The web service uses a back end Oracle 10g database on the dev machine and production machine. I cop...
I have a text file with many records similar to the following:
AAAG+7AAHAAAF1sAAE TUBO_00204G_R2_C4_D125:26515 TUBO_00204L_R3_C5_D A188 21/07/08 21.01.54 4444 123.45
The field separator ...
I have a oracle db running on a linux maching. Now, I need to access the db from my windows XP machine. I downloaded and unzipped the oracle instant client on my windows machine. I added the ...
I have daily/weekly/monthly reports to generate in pdf format.
Currently they are being run via Report Builder 10.1.2.0.2
These reports have 2 User Parameters for dates (START_DATE, END_DATE...
Hi,
Oracle 10g Express Edition, which has a cap on resources, i.e. 1GB RAM and 4GB Disk Space. How can one determine that the resources are reaching the reaching its limit and it is time to...
All, I have a requirement to do a bulk extract,nightly extract from 5 of our tables and insert the data using a dblink to a rempte database. All,
I have a requirement like this
1. I will hav...
folks,
bit of a curly one, I have XE running nicely on a 2000 box, am setting up an ASP website on a 2003 web server and want to install the XEclient so I can get an ODBC connection happeni...
Guys
I have a 2 node RAC environment running on enterpise 5 linix where my PROD database sits. I have taken a full database copy inc archive logs. Oracle created these on my ASM instance lo...
I would like to automatically mount a database instance on Startup in Windows.
Can I do this without writing a script file/batch file?
I have set the ORA_SID_AUTOSTART = FALSE but I nee...
Hello,
I'm using oracle 10g and a question:
if a table is locked with select for update can I update it without "where current of" statement in the same transaction? And if the lock is r...
When trying to search for patches through the Oracle Enterprise Manager Database Control utility on an Oracle 10.2.0.2 installation on Windows Server 2003 R2, I receive the following error:
...
Hi, I have installed oracle 10g express. In control->Administation tools->services, I could see OracleXETNSListener is started. Besides OracleServiceXE is also started.
I could use sqlplus...
Is there a way with Oracle SQL to select a column if it only contains numeric characters, else return NULL for that field?
I have been using the is_number function in my sql:
and is_numb...
Hi,
Is it possible to download ORacle 10g Enterprise edition for Free. If Yes, thentell me how can i download the Software.
Currently I am using DECODE functionality like this.
USERAL CHAR "DECODE (RTRIM(:USERAL),'', NULL,'<>', NULL,NULL,NULL, RTRIM(:USERAL) )"
In this case i have identified...
hi,
I have an interview coming week and the requirement is below:
Programmer/Prog Analyst - Development: Prepares Specifications. Participates in design walk through. Constructs applications...
When I try to run a job to establish a vpn connection using dbms_scheduler, the job status says failed with the error :ORA-27369: job of type EXECUTABLE failed with exit code: The code segment...
HI guys
I have a temporary tablespace with 26 GB size, i think that is to much. The problem is that this table has been full for 4 or 5 months.
I have some questions about it.
1.- C...
