Search results for query: *

Hi, guys. We have a problem with a developer here, and I need find out the exact SQL he ran recently. I have no idea which sql he ran, it could be SELECT, DELETE, or UPDATE. The only info I have is his user name. I started to do my research last week, but no luck. I am not very familiar with SQL...

HELP!!! We need transfer all 52 million records from table apple into banana, we have 36Gb free space available, and I have already put the database into simple recovery mode, but the transaction still ate up all free space and failed. I have been trying several days using either the Import...

We need disable some user accounts. I know we can open SAM and deactivate user accounts, but there are hundreds of them and it takes too long. My boss said it can be done with 'usermod' and asked me to write a script to do it. However, I checked the man page of usermod and I don't think it can...

We have setup log shipping on our prod database APPLE. The destination database is configured to be in standby mode. The log shipping has been running well, and the destination database is always in ReadOnly mode. And today we have stopped log shipping. But by mistake, the source database was...

We have a Oracle9i database on HP server. I logged on as myself to our Win2k server, I created ODBC using "Oracle in OraHome92" driver. Then I clicked "test connection" button, typed in password, it works fine. But, my client logged on as himself to the Win2k server and can not test the ODBC I...

Our developers want me to create ODBC for Oracle on a SQL Server box because they got error "The Oracle(tm) Client and networking compenents were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3(or greater) client software installation. You...

Our Transaction log file is growing very fast (2G per 5minutes) and fill up the disk. I have already set the database to be in simple recovery mode. Also I have schedule a job to run 'backup log ... with truncate_only' and 'dbcc shrinffile (...)' every 5 minutes, but it does not work because the...

I got the same error as thread962-928378 when running command "backup log ... with no truncate". I have been playing with it for two days, and I always got the same error either try it with T-SQL or Enterprise Manager. This is critical to point-in-time recovery and I got to make it work. Help...

I need test something as another user, but I don't know his password, and it is not allowed to change it. There is a way to switch to another user if you are dbo, and I have tried it several weeks ago. It's pretty simple, but I forgot how. I usually write down detailed notes about those 'how-to'...

I am a DBA but was required to let a user ftp some files from our HP server. I created UNIX account for him and copied my .profile into his home directory, but when he tried to open ftp , he got error '530 user test access denied... login failed'. I have searched on this forum and checked...

We have a database DEV on a Win2k server, and we backed it up and restored it on the same server as TEST. Now if we run the following query: Select a.* from ovrn_nielsen_qtrh_final a where a.CALL_LETTER_ID=173329 and a.NLSN_FIN_QTR_DATE>='9/14/2005 8:00:00 PM' and...

I know we can check /etc/passwd or echo $SHELL to get the default shell, but how to check which shell I am currently using? For example, if my default shell is ksh, and after I logged on, I changed to csh, then Borne shell, then ..., and I want to know which shell I am using, is there a command...

We have a database PROD on server1, and the boss asked me to clone it to server2. But, he wants only the structure and does not want any data in it. I have done some research but could not figure out how to do it. If anybody can tell me how to do it, that would be great. Your help is very...

My boss wants me to make a script to startup/shutdown our Oracle applications automatically when the Solaris server is rebooted. I made a script /etc/init.d/oracle.sh, created a link in /etc/rc3.d and tested it. Which is interesting is, it works fine if I run it manually, but doesn't when the...

My boss asked me to find out how to start/stop SNMP on HP. I have reviewed HP SNMP/XL User's Guide, it mentioned configuration files SNMPSAMP(SNMPSAMP.NET.SYS?) and SNMPCONF, also it mentioned SNMP utilities such as snmputil and snmpcontrol. But I could not find any of them on our server. Could...

I have setup the log shipping following the LearningTree's training materials on our servers: Source: Northwind on server prod Destination: Northwind2 on server dev After the plan was created, everything looks fine. The new database northwind2 was created successfully. I checked on server...

I am a Oracle DBA but new to DB2. The boss wants me to clone a DB2 database DEV, but for some reasons, we must do it in two steps: first, create an empty database PROD from DEV. The new database PROD must have exactly the same structure as DEV but it's empty. Second, export/import data from DEV...

I need to tar the Oracle Application Platinum42 CDs to tape and send it to our client today. The CDs have been staged to /plat42. The command 'tar -cf /dev/rmt/0c /plat42' returned errors to me. The error messages are 'Directory nesting too deep'. Could anybody help me with this? This is...

using command 'tar -cf ......', and today we need to backup some other files to the end of the same tape. 'tar -cf' won't work because it will rewind the tape first and the files we backed up yesterday will be removed. Could anybody help us to do this? Thank you so much.

I am an Oracle DBA and I am new to Informix. Now I need to delete some records (for example, the first 100 records)from a table in Informix for test purpose. Could somebody tell me how to do it? The query in Oracle database should be: delete from test_table where rownum<101; But it does not...