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!

Register Log in
  • 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: *

  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

    Thank you both, TEA will overwrite only tables. Is there anyway without dropping users and directly overwrite all objects, including view, stored procedure, packages... Thanks Claire
  4. 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
  5. ClaireHCM

    Getting permission to access table in sql server

    Could you please type out the exact error message that user is getting? Could you also try IP address instead of server name? And also maybe try other drvier like "SQL Native Client"?
  6. ClaireHCM

    Eliminating zero sum while inserting

    I can't do testing. But give it a shot, Insert into BEGACCOUNTINFO (ACCOUNT, ACCOUNTNAME, ENDBAL) select ACTNUMST,ACTDESCR,SUM(PERDBLNC) FROM [EQU-SRV-DB].RCG.dbo.Actg_1FR WHERE PERIODID <= '02' GROUP BY ACTNUMST, ACTDESCR having SUM(PERDBLNC) > 0 ORDER BY 1;
  7. ClaireHCM

    Getting permission to access table in sql server

    Can you have him connecting to the SQL Server database through other client tool like query analyzer or enterprise manager. since it's using trusted connection, so login as sysadmin into the box and run sp_helplogin to see whether his NT login is there. Please also go to the specific database...
  8. ClaireHCM

    Getting permission to access table in sql server

    I dont think it's anything to do with the db owner as sysdba. double check the following things. 1. The connection strin information is correct, including login name, password, ip, server name, port number. 2. Make sure the login is enabled and can access the database. Please try this out
  9. ClaireHCM

    DTS Package not selecting all the data in the query

    In DTS package data transformation task, in stead of selecting the table name, you could replace the table name with select query. In the select query, try to convert varchar2 to some other data type that could be recognized. This is often an issue while migrating data in between different...
  10. ClaireHCM

    Server move

    Hmm....In that case, I am not sure. My suggestion is to work with Sys administrator or network admin for the server domain move.
  11. ClaireHCM

    Server move

    Here are the different approachs you can take. 1. You can use backup restore to move the databases from one server to other. -- No downtime 2. Use detach and attach --Downtime required 3. Take DB offline and copy the database files over to the other server, once copy completed, bring first...
  12. ClaireHCM

    table/view to see locked out accounts

    I am not too sure what you meant by "accounts get locked out", are you saying the accounts are disabled in the server? Or the account password are changed? syslogins may give you some info you need.
  13. ClaireHCM

    Copying Table and Data

    1. First script out the table structure from first server 2. Export data using BCP 3. Import data using BCP or BULKINSERT 4. If you are familiar with SSIS/DTS, using SSIS or DTS to transfer data. You need to migrate DTS to SQL 2005 environment if you decide to use DTS to transfer.
  14. ClaireHCM

    date

    You can call a expression transformation. Pull the date string from flat file.Change the input port name to IN_Date. Uncheck the output port of IN_DATE Add a new output port called "Out_DATE" in the expression transformation, set it date/time datatype. Define it as...
  15. ClaireHCM

    how get only new rows?

    1.Define a mapping variable say $$Max_Date 2.In the Source Qualifier, define Source filter to be Date_Col > $$Max_Date 3.Let Date_Column go to Expression 4.In the Expression,add a variable port. Define as SETMAXVARIABLE($$Max_Date,Date_Col) 5.Drag the Date_Col output port from expression to...
  16. ClaireHCM

    Informatica Variables

    how about defining variable in every transformation. And input the required value from the last transformation?
  17. ClaireHCM

    cannot connect to server

    You need to check the Informatica Server -- Informatica Server Setup -- under server tab the "Server Name" is exactly the same as the one you configure when adding new server in Workflow manager. And restart the informatica service to apply the changes.
  18. ClaireHCM

    round and sum

    Sure you can, SELECT payment_method, Round(SUM (subtotal),0) FROM orders group by payment_method order by payment_method SELECT payment_method, Round(SUM (subtotal),-1) FROM orders group by payment_method order by payment_method SELECT payment_method, Round(SUM (subtotal),1) FROM orders...
  19. ClaireHCM

    problem w/ dynamic database dropping via DDL

    oops, I made a mistake, please replace Print ('IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = ''' + @dbname + ''') DROP DATABASE [' + @dbname+']' ) with Exec ('IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = ''' + @dbname + ''') DROP DATABASE [' +...
  20. ClaireHCM

    CONDITIONAL UPDATE

    This is one way, but personally I dont like it, because it scans the whole table. update Customers Set Dist_Code = (Select Case County when 'WY' Then 'A1' when 'SG' then 'A2' when 'DG' then 'A3' else Dist_Code end) ,PACKING_NUM = (Select Case County when 'WY' Then 8 when 'SG' then 9 when...

Part and Inventory Search

Back
Top