Search results for query: *

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

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

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

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"?

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;

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

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

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

Hmm....In that case, I am not sure. My suggestion is to work with Sys administrator or network admin for the server domain 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...

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.

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.

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

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

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

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.

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

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 [' +...

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