How to Install Oracle 10g Rac on Sun Solaris 10 X86 using Vmware
All,
It's been a while now...but what is the process of command in a sql file to execute an Oracle stored procedure or function?
This file will be invoked with the @ on a SQLPLUS line. ...
I wanted to read the data from the flat file into an oracle table I want to use Utl file package because each time I will be getting a new input file ...............I have devised a way to cap...
I have installed oracle 10g Express. Everything works fine
I can able to connect using SERVICE_NAME / SID = 'XE'.
Is there any way to change SID to 'EXTERNAL'?
Advance thanx,
Radhakrishna
Oracle 10g:
SELECT Trainee_TBL.LastName,
Trainee_TBL.FirstName,
Apt_Building_TBL.BuildingName,
Apt_TBL.AptNumber,
Apt_Type_TBL.ApartmentType,
Apt_Type_TBL.PricePerNight,
Apt_Rental_TB...
Hi,
I need to convert latitude and longitude to UTM-coordinates, ideally, without moving the data outside the Oracle database. As far as I can see the only option I have is to move the data...
hi..
I'm facing a problem when I try to connect to any user in oracle database:
ORA-01033: ORACLE initialization or shutdown in progress
when I go to dos and connect to sysdba
and write
s...
I am creating a new 10g database. The create database script was completed but the database hung when running catproc.sql.
I exit out of that session and now getting:ORA-39700 database must ...
Unable to connect to Oracle XE from Toad/SQLPLUS with a given User/Password. I'm able to connect to the database from the Oracle 10g Home Page using either SYSTEM/admin or SYS/admin or any cre...
I am inserting this sql statement into an Oracle 10g database:
INSERT INTO ActivityLog(ID, date) values(41, to_date ('02-27-2007 09:17:55 PM', 'MM-DD-YYYY HH:MI:SS AM'))
It appears to wo...
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...
Hi,
I need to extract some records from an unpartitioned table with 44 million rows and I am not the DBA. There is an indexed date field I am looking at to pull just the records for this y...
Hi,
I tend to do an RMAN coldback of my DB using a "backup database" command in RMAN and it works fine.
I am trying to use RMAN to backup the archivelogs but it keeps spitting out the f...
How do I correct export just the ORACLE Schema ?
I am running an upgrade from Ora8i to Oracle 10G, need the correct syntax;
Here is what I have been using;
exp userid=system/******** fi...
Hello,
I want to install new Oracle 10.2.0.1 for Windows 32
Than I want to install all patches to have my database up to date.
Which patches and in what order should I apply?
Do I only...
how to clone oracle 10g database by copying datafiles?
I'm trying to fire this trigger but I get ORA-04091: table ... is mutating, trigger/function may not see it
since I'm querying the same table the trigger is firing on.
I tried declaring pra...
Greetings,
Do anyone have any step by step documentation for installing Oracle 10g Rac R2 on Sun Solaris 10 X86 using Vmware?
Hello,
can somebody please tell me how can I write a simple sql query with 1 parameter passed like below in a stored procedure syntax? Though I write sql server stored procedures, I've neve...
Question is regarding Oracle 10g database; I am involved in some capacity planning need some guidance on estimating max byte size a column can use up to. I have columns of datatypes, NUMBER, T...
ORACLE 10 G
Hi
I have created a strored procedure and it compiles fine but Im not able to see any results so therfore it must not be executing. Ive done a very basic one to test but it...
Hello,
I am having major Oracle 10g issues. I'll try to give a brief and succinct synopsis of what has happened to date.
1. A database instance was able to be successfully created, and ...
I am getting too many Wait Event: resmgr:cpu quantum.
i have oracle 10G and the parameter value for
resource_manager_plan string SCHEDULER[0x22B0]:SYSTEM_PLAN
how t...
I have an Oracle table (Oracle 10g2) that has been partitioned based on a date (PARTITION BY RANGE (DATE))
Every year is in a separate partition.
For example:
PARTITION 2005_PART VALUES...
After a recent upgrade to 10g, a query that used to work is failing....
I'm attempting to run the following query:
SELECT DISTINCT id3, id1, id2
FROM (
...
