How to analyze the AWR report generated by awrrpt.sql, i am newbie for AWR
i have a oracle 10g install and i can open up the GUI called " enterprise manager console" however on certain functions ( like tools ....backup) it tells me to use the "oracle enterprise manag...
hi
i have two database DB1 And DB2. DB1 is oralce 9i database and user is usr1 and second DB2 is oracle 10g and user is usr2.i want access table t1 which is exist in usr1@db1 from usr@db2...
We are building a new Oracle database, and are thinking of staadardizing our (many) numeric columns to one of three precisions:
number(10) counters, static / reference table ids (surrogat...
I am using RMAN on a Windows server to backup my database.
I have set the following retention policy
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS
My database backup sets and ...
I am trying to run a program that was developed by another party. The program is a C#.NET application that was developed against an Oracle 11 database and Oracle 11 Client/SDK. The machine I...
In short, Truncate removes all rows from a table, leaving the table empty and the table structure intact. What do they mean leaving table structure intact? Do they mean Values () gets deleted ...
I am very good with SQL. But I urgentely need o lern how to use TOAD for Oracle
I'm having a problem connecting thru SQLPLUS at the command prompt on a Windows 2003 Server. See the following:
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp....
Hi
I have an Oracle 10G database where we currently import data from another 10G database using the impdp facility initiated by a unix shell script. This works fine and takes about 40 minutes...
The follow SQL code extracts data from a oracle table, it works just fine..
How do I change it to filter and return only records with a Y as the value for the column ACTV_YN?
How do I run th...
I've used bulk collections sparingly in the past, so I'm less knowledgeable in that area than I'd like to be. Specifically, using them in cursors! I'm trying to read through a table and pick...
We just isntalled the lastest version of Oracle's Applicaiton Express (APEX) and are now trying to setup our first application. We've figured out how to setup workspaces, but we''ve not been ...
I am trying to insert a web link (using the varchar type), referencing a google map location, into a table and am getting rather strange behavior. I get the error ORA-00911:Invalid character. ...
Hi experts,
Please help me on the following strange problem. Thanks in advance!
My JSP Web application runs on Weblogic server (ver 8.3.1), uses Oracle 9i DB. It's main process is
- Step ...
I am trying to install the universal edition of oracle express edition 10g in my PC, which is running on microsoft windows XP service pack 3. The installation completed without any issues and ...
Hi, I want to build an after insert trigger that inserts a row into table A after inserting a row to into another table B is done, but I want some restriction before the second insert statemen...
I want to create a stored procedure where I
1) Declare a global temp table A
2) Populate this table A.
3) Then return the resultset in a cursor where the JOIN refer to this temp table A
...
Hi,
I am doing level 0 backup and level 1 hotbackup of the DB using RMAN directly to TSM tape. I want to know how to get the size of the backup after the backup finished, evryday.
Cna a...
We have processes that run within Informatica that perform transformations on data using SQL. An error occurred tonight that is now causing our workflows to fail. I've pulled this informatio...
Our SMALL business is condering a database upgrade and woule like an expert's view of how Oracle 11g compares to MS SQL 2008. Is there a clear winner between the two? To help with the process ...
Hi,
I have two servers, one with our production database, and another hosting a standby database. Each also has its own catalog database as well. I took a full rman backup this morning at...
i have the following data:
A B C
Adata1 dataB1 100
Adata1 dataB2 200
Adata1 dataB3 300
Adata2 dataB4 50
Adata2 dataB5 340
Adata2 dataB6 400
What would be the query in order to get ...
Hi,
I'm trying to do a simple insert into an Oracle table I just created. This is the error message I'm getting...
ORA-01465: invalid hex number
This is the statement I'm using is...
...
I'm loading tables into my Oracle 10g database using "IMP" and I get duplicate constraint errors when I don't delete all the tables. Can I use "Contraints=N" to avoid this error which preven...
