Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ClaireHCM
  • Content: Threads
  • Order by date
  1. ClaireHCM

    READ UNCOMMITTED or NOLOCK on Oracle

    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
  2. ClaireHCM

    Add datafile to UNDOTBS

    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...
  3. ClaireHCM

    impdp overwrite

    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
  4. ClaireHCM

    Oracle and Sybase Box

    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?
  5. ClaireHCM

    Informatica Service Cannot start

    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...
  6. ClaireHCM

    WorkFlow doesnt run -- "Cannot Connet to the Server XXX"

    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...
  7. ClaireHCM

    Distributed Query Issue

    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...
  8. ClaireHCM

    Why sometimes when query is not wor

    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)?
  9. ClaireHCM

    How to get date without conversion?

    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...

Part and Inventory Search

Back
Top