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...
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 ...
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...
I have a table S with the columns a, b, c, d, e and counter which are all part of the primary key. However, I believe that the counter column is redundant and does not need to belong in the pr...
Hello,
in Oracle I have made a table named 'members'. If I save the table, the name is converted to upper cases ('MEMBERS'). Is het possible to maintain the lower case in the name?
Thank...
Hi all ,
i have to convert following char data into date format in *DD-MON-RRRR HH24:MI*. The data is
*(mm/dd/rrrr hh:mi:ss PM)*
8/11/2009 12:12:39 PM
8/8/2009 12:12:39...
Hello,
I do have a SQL Server database and an Oracle database. I have made a connection between the SQL Server database and the Oracle database by creating a linked server. In Oracle I do h...
Hi All,
i need to put the output of my sql query into a unix loop and check that the output increments.
I am just check archive logs produced in the last day and from the output i just wan...
What is SCN and What is Multiversion Concurrency Control?
how does SCN affect Multiversion Concurrency Control?
I wish to write a query where the value of one of the columns is null. How can I do that? The values are input via an Oracle Form For example,
Select * from MyTable
where code = :code
an...
I wonder if you could help me identify speed issues in the following sql for Oracle. This particular statement is producing about 220 lines of end data and taking some 20 seconds to run on Or...
We have 2 blocks.Both blocks have the realtionship with each other.After changing the child block record and
going back to parent block i am getting message like 'Do you want to save
chang...
We recently had to purchase Oracle 11g for a new app that we are implementing. I am used to MS SQL and completely new to Oracle. Where is the interface for management/query/config like in MS...
Where can I find out the Oracle System Identifier (SID)? I am using Oracle XE.
Thanks in anticipation,
Artic
I need very specific instructions on how to pass the parameters from a web based form to an oracle form. From the web based form, we are using a link to call the oracle form and need to pass ...
Hello Experts,
Kindly suggest some resolution to this Issue
Errors in file /oradisk/app01/oracle/product/10gDB/admin/ibsora/udump/ibsora1_ora_19299.trc:
ORA-00600: internal error code, ar...
I created a database with Access 2003. I added security to the database with the wizard. The users use the shortcut to get into the database. Recently, our company pushed Access 2007 to all...
I don't know what's wrong:
eg: where to put declare, why can't have two into, etc
Thanks!
I'm coming from SQL Server
Is there an Oracle GUI Tool equivilant to Sql server profiler
my main goal is to find out what is being
executed against a database "sotred procedure , sql stat...
I'm wanting to create a procedure block to create a report and then export it to Excel.
I have my select query but I'm confused about the report function. Should I send it to a temp table? ...
I have created a record group and LOV for a text item on my form. When I execute the form and press F6, the LOV shows up with the list of values. However, when I select any of the items on the...
Hi EE,
I have an Academic_Period of 200920.
I used SUBSTR to isolate 2009.
I need to add 1 to 2009 to create: '31-MAY-2010)
this works: TO_NUMBER(SUBSTR(Academic_Study.Academic_Period...
Hi
I want default printer value from window registry. i m using webwtil as given
:block_name.item_name =CLIENT_WIN_API_ENVIRONMENT.Read_Registry('HKEY_CURRENT_USER\Software\Microsoft\Wi...
can i run 2 server application on a dedicated server? i got phpmotion server , wowza media server to install
# 2 x Opteron 2216
# 2 x 2 x 2.4 Ghz
# 8 GB RAM
# 2 x 500 GB
How to install oracle from remote machine using like (telnet,ssh)?
Is it possible to install oracle from machine? if let me know the steps.
thank you in advance
