I need comparative study of oracle 10g or 9i and IBM db2
I am installing Oracle 10g Grid Control R2 on RHEL 4 and the installation keeps failing at the very end on the OMS Configuration section of the install. I viewed the config log file for the ...
Can you please provide the detailed steps that one needs to take in order to upgrade an Oracle 10g Database (10.2.0.3 to 10.2.0.4) on Microsoft Windows Vista? If you have the patch numbers th...
Hi all,
I need to change the character set of my Oracle 10g DB. This is on an HP-UX platform. I got the go ahead to trash all data and recreate the DB.
Using the export DISPLAY I am runn...
we are using windows 2003 server 2003 64 edition with a hp proliant 570 server and we are trying to install oracle 10g for wthis windows. after a while give us this error oui-25031
Hi Experts,
While using the testxmlproc procedure I am having problems parsing a date which is the format dd.MM.yy
I have tried to use the following procedure to set the date format :
C...
Hi there, I've done something a bit silly. :( In my test Oracle database I ran a v large transaction which bloated the undo tablespace to over 9GB. Since this db is running on my laptop wh...
Oracle 10G Forms developer tutorial
I am new to Oracle DBA activities. I am using Oracle 10g database. Due to space constraint I dropped all the objects (not the user) which was imported by me earlier. But still i didn't find an...
Can not configure any Database in Grid Control
OK I have a new windows server that I installed Oracle Grid Control R3
I can add agents and they work at the operating system level but the...
I need Oracle pl/sql code to transpose a number of tables into one table. The original table structures has lots of columns and a few rows. I want a few columns and lots of rows. Sample tables...
Hi
Running Oracle 10.10.x version
I discovered 1000s of rman_*trc files in /u1/app/oracle/admin/rman/bdump/
the discspace of U1 reached 97%
My questions is :
- should I delete these fi...
I got the following errors in my alert log file:
Tue Oct 23 11:31:08 2007
Thread 1 advanced to log sequence 1136
Current log# 1 seq# 1136 mem# 0: /opt/ora/oradata/owbprod/redo01.log
Tu...
I am trying to schedule backups through the OEM 10G console, I have Oracle 10g installed on a 2003 domain controller. (I know, not good) When I try to test my credentials I get the following e...
I recently installed Oracle 10g and TOAD 8.0. I am able to tnsping a local database on my laptop and a remote server. I am also able to connect to both databases in sqlplus & at the command pr...
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...
Hi,
Can someone advise me of how I can find out my proxy server details? Thanks.
I am working on ORACLE EXPRESS EDITION, in chapter 6, in page 6-3, it says UNDER NAME, enter the proxy s...
I have reached my 4GB limit on the XE database, and when I try to delete data from a table I get error messages about the limit of 4GB.
I have now dropped several schemas, but the limit is ...
If you attempt to TRUNCATE a table that has related rows via foreign key in another table, you get an error message.
I know that with DROP or DELETE you can use the CASCADE option to get ar...
I am using Putty to install Oracle 10gR1 on my RHEL4 server.
Specified X11 forwarding on Putty and I am able to use the graphical components of RHEL like lvm for example. But every time I run...
I am running oracle 10g on windows 2003 server. I installed oracle 10g db and then oracle companion (html db and http server). Everything is great until i reboot. Then I get a service failu...
Hello all,
Can I convert a clob datatype to varchar2 or char?
Thanks
hi,
how to pin plan_table in memory in oracle 10g?
Hi Experts,
I have an oracle 10g database on a linum machine which i want to import into a windows machine. These are the two steps i have done so far..
1) Took an export of the full datab...
Hi Folks,
I will try to be as descriptive as possible so I pre-apologize if I run-on a bit in my problem description or if my technical terminology (and knowledge) in some areas may be vagu...
