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: *

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

    How to find the exact SQL a user has run recently

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

    HELP!!! 36Gb log file!!!

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

    How to deactivate a login

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

    stopped Log shipping, but can not change the read-only mode

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

    ODBC works for me, but not for my clients

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

    ODBC does not work

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

    Is there anyway to turn off logging completely?

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

    "backup log ... with no_truncate" failed

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

    How to login as another user to test if you are dbo?

    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'...
  10. mm8294

    "530 user test access denied" error with ftp

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

    2 exactly same db on one server have big difference in performance

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

    How to check which shell I am using

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

    Need clone a database to another server, but don't want any data

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

    startup and shutdown script problem

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

    Where are the SNMP config files and utilities located?

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

    LogShipping completed, but new record not added to the standby db

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

    How to get a DB2 database's structure?

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

    Urgent! 'tar -cf' get error 'directory nesting too deep'

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

    How to attach files to a tape? I backed up some files to a tape

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

    How to delete the first 100 records from a table in Informix?

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

Part and Inventory Search

Back
Top