Need Oracle PL/SQL snippet that determines whether a role currently exist. If the role does not exist the role should be created. Trying to avoid Oracle error: ORA-01921 role name 'CABG' con...
oracle 10gR2 . the default snapshot interval for AWR (Automatic Workload repository) is 1 hour for 'TYPICAL' init.ora setting
Can anyone have the commands I can use to change the interval...
Windows 2003 server with 3 intances of Oracle - 2 running in Oracle 10.1.0.3.0, 1 running in 10.2.0.2.0.
One of the databases (DB1) running in 10.1.0.3.0 is producing vast quantities of error...
Hi All,
I am having a problem with Oracle 10g 10.1.0.2.0 on red hat. I just bounced the database and then the server. Now when I attempt to start it I get
"ORA-16019: cannot use db_reco...
Hi:
We have a customer who has an applications using Oracle 10g, Sybase 11.9.2 and Oracle Apps 11.5.10.2 and varied programming languages such as Pro*C, Java, PowerBuilder et al. These appl...
i would like to know it's possible have a table in memory ram
Hi all,
I am newbie, we need to export a user objects from one database (Oracle 10g) and import to another database (Oracle 10g) [both in same platform,Windows XP]. I am a newbie and i have...
I'm getting an oracle exceptioin while running the following.
OracleParameter[] myParameters = new OracleParameter[] { new OracleParameter("SELECTEDREGIONS", OracleDbType.RefCursor, Parameter...
Have only asked one question in the past, but now I need help so here goes -- as clearly as I can...
I have a job that needs to be run on a regular basis. The job takes some text files (pa...
Hi Experts,
In my Oracle-XE, I have two users user1 and user2. I've created Employees table using user1.
How can I give or grant permission to user2 like select, update, delete or insert? ...
hi
i want to get a report in xls ...i can do thru spool...
but the problem is the format is not good..
the display is exaclty like in sql plus. but i want it in column. i tried to separate...
Hi there,
I have a schema with a procedure which inserts records into two tables. The first table has an insert trigger to populate the primary key column. The procedure then uses that in...
The Oracle User called QUIZ contains the table called CITY has over 2 million records.
This table has 20 columns, no importance for their names.
Please suppose that 3 columns of 20 are the f...
I am having trouble getting the universal installer to pop up. New install on fresh RHEL 4.5 install on Zvm.
This is the 64bit version and I have the 64 bit Z linuxoracle downloaded that I am...
I'm trying to perform a decode on a date field. If the field resolves to 12/31/9999, I want to save the date as a NULL. The record is saved in the table as a DATE in the following format: MM/D...
Many-to-many in Oracle.
It appears as though I am over complicating things. I have an ER diagram with a many-to-many link. I'm using Oracle as an Object-Relational-DBMS. I know I have ...
Oracle 10G
Hello,
I have a database link set up using Heterogeneous Services ODBC.
here are the initodbc.ora details
HS_FDS_CONNECT_INFO = "DSN=ser;DB=myDB;UID=123;PWD=xxxx;HOST=my...
Dear!
I am new to oracle. I really appreciate if having responds from you.
I am developing an application using Java for programing and Oracle for storing data. User can query the data using...
I am making database connection from a web application and when I see the connection status in the database, it is showing many database connections with "SNIPED" status. Please help me to und...
Hi,
From this link:
http://download-east.oracle.com/docs/cd/B19306_01/install.102/b15667/pre_install.htm#sthref258
It says shmmax should be half the size of physical memory
I have a se...
Below is the insert statement contained in the procedure which works when run in SQL Plus (I had to use a fixed po_item_id to test it)... I have also included the trigger, procedure and sql s...
Hi!
I have installed on two Windows Server 2003 hosts Oracle 10g products. Server PCO206 hosts three databases (one to be removed soon). They are called according to the project name 'Elba'...
Hi:
I'm doing a full database export using datapump in Oracle 10.2.0. Last time it ran, I got the following message:
Starting "SYS"."MISASTOR_EXPORT":
Estimate in progress using B...
Hi,
Our company has a Oracle database installed on a private network, no outside contact to Internet, etc. We only use two accounts to log into the db. Can I delete the other accoun...
I have a working java source(from getconnection and modify and update columns) which manuplicating data and update tables.
I have mind to call java sources or java classes rather than conver...
