Search results for query: *

Hi all, I have 100 server group by location: State1 servername1 servername2 State2 servername1 I need to move all those groups and server registration to another pc. I exported the list but how do I imported on the other pc? I found 1 solution involving exporting the REGISTERED SERVER X...

Hi everyone, Is there a way to create a script that can give you the following? username, what database is using, what role it has, what access have thanks in advanced

hi, Im trying to do a simple thing, waiting for a user to input a value so i can pass it to a sql statement and do a select according to their input like: Declare @USERINPUT varchar(50) Select * from MYTABLE where MYFIELD = @USERINPUT But the trick is I can't use it on a store procedure...

Hi, I'm trying to export a subset of data using a date field using this: exp user/pass file=flename.dmp log=filename.log tables=MY_TABLE query=\"where as_of_dt='08-31-2007'\" and this is the error it gave me: EXP-00056: ORACLE error 932 encountered ORA-00932: inconsistent datatypes Export...

HI, I have a Database Called PRODDB the owner is USER1 and a table called MYTABLE that was created by USER1 and also USER1 is owner of the table. I have setup the exact same database and user in TEST enviorment. In test a DTS that reads a file and upload it in a table and do a simple select...

Hi guys, i want to do transaction log backup for an audit but my software conflicts with the directory of the transaction log in prod so I want to schedule another backup after 30 minutes from the original transaction backup in prod to capture the data from my new directory. Qustion if i have...

Hi , I'm looking for a way to deny users from droping tables in the BOL i cant find a revoke statement if i write this: revoke drop table to test i get thios error privilige DROP <object> may not ber granted or revoke is there a way to to do this? thanks in advanced

hi I have a field that contains this data : 12345.0 I want to get rid everything after the DOT 12345 the field is a nvarchar 40 how can i achive this? Thank you

Hi I have a table with a field char (10) the records on that field some have 3 spaces on the left and the rest doesnt have spaces on the left example: the line underscore (___) means space in the left for demostration purpose "__MYDATA" "MYDTA__" I want all the data to be like this...

Hi, I just want to do this: delete from Tablename where Field in (select Newfield from SecondTable where Newfiled = 12) (12200 records) <----this result when i want to capture it and insert in a table. How i can achive this i tried print @@rowcount but it returns the value 1 meaning 1 row...

Hi pros I know theres a lot of log files on my hp-ux 10.20 that i should delete cause of disk space problems but is the a list of directories where log are located so i can delete them? I saw a document of a thread that has it but i cant find it... any help will be very very appreciated...

Hi pros Im doing a DTS to load a txt file, but the record size on the txt is 1,020 in lenght, while im creating defining the columns and i go beyond 994 and save it i loose my definitions but if i stop at 700 i dont loose my definitons. is there a limit on comlumns or record lenght for a txt...

Hi pros I have a user that is messing around in a database,I need to know when that user last logon or made an update I only need to know the time and date appreciate any help on this...

Hi All does this function works on 8i PERCENTILE_CONT? I have this error when running SELECT BR, ACCT_PROD, AVG_BOOK_BAL, PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY (AVG_BOOK_BAL)) OVER (PARTITION BY (BR)) FROM IATMDC WHERE DATA_SRC_CD IN ('IM','ST') AND AS_OF_DT =...

Hey guys!,, I wonder what is the spatial option in oracle? what does it do? the documentation i found just says is used for web development etc. the explanation is very generic... thanis in advance!

Hi Guys! I want to store all transactions made by users (by transactions I mean SQl statements) to store it in a different table. I mean If a user ran an SQL statement to update delete or anything i want to store it for tracking. I know monitoring programs show in realtime what the user is...

Hi guys I'm trying to do Isolate a car then change his background with a 3d scene done in maya, after I rotoscope the car (due to the lack of blue/green screen) i just use the cut out car without adding a matte with auto-trace? I'm kinda confuse since i read that you have to put a white...

Hi Guys!! Im doing this SQL statement to create a spool file with the results, but the firstline is always in blank then all the record are written: --set pagesize 0 set heading off set feedback off set linesize 255 set verify off set termout off set echo off spool /MyunixPath/result.txt...

Hi guys! Question If someone ask you "if you have installed partitioning on ORACLE?" Are they referring to the ability to partition tables? or what? Thanks in advance!!!

Hey guys! I need to know wich tables i should query to know wich options are installed in oracle (partitioning, performce pack, etc) and users!!! Thanks in advance