Hi,
In SQL Server, I can do
1. select * from tb_name (nolock)
or
2. SET TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED
To avoid blocking due to lengthy select operation.
Do we have something like this in Oracle?
Thanks
Claire
We have a production process that fills up UNDOTBS very frequently and that causes process to be aborted.
In emergency, I'd like to add more datafile for UNDO tablespace, would it drop/block/reject user transactions?
In stead of adding new data file, would it be better to just change existing...
impdp can overwrite tables but what about views, sequences, plsql objects?
Is there anyway to quickly clean up existing objects so that impdp can complete with "object already exists" error?
Thanks
Claire
I am buying a Unix Box (Or Linux Box) which Oracle and Sybase can run on . Better it could also support DB2/UDB.
Could any body guide me how to proceed?
Hi,
When I tried to start Informatica Service, it allowed me to start, but soon after few secs, it returned back to stopped.
I checked application log in EventViwer, 2 errors logged.
One is "(9984|9756) Error in opening Server Port [5001] to listen for client connections." .
The...
Hi,,
I am new to Informatica.I just install informatica in my machine.
Everything else is working fine.But when I trigger "Start WorkFlow", it always prompts me that Cannot Connect to the Server XXX.I think something wrong in my server or repository configuration.
In the Informatica...
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=W:\MyExcel.xls', 'select * from [Sheet1$]')
which works on my local server with Microsoft office XP Professional installed
But keep on failing on the QA server which has MDAC installed only, no Microsoft Office installed...
Why sometimes when query is not working or working poorly?we will be suggested or reminded "did you set nocount on ?"Why set nocount on affect the result of our query?how does it affect the result(or should I say performance)?
I saw this question in some other forum.How to do this without conversion?
-----------------------------------------------------------
Hi , i just want a select statement can bring me a date, but "DATETIME" !. I need it because later i want to perform other calculation with these...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.