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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by patrick118

  1. patrick118

    Maintenance plan logging or tracing

    I have a maintenance plan which fails. In the logfile I see the following message. Check Database Integrity (xxxxxx) Check Database integrity on Local server connection Databases: All system databases Include indexes Task start: 2011-08-08T06:00:05. Task end: 2011-08-08T06:00:05. Failed:(0)...
  2. patrick118

    SQL 2000 all db sizes

    I can sleep now. Thank you.
  3. patrick118

    SQL 2000 all db sizes

    the name field is the name of the filename it can be different from the name of the database
  4. patrick118

    SQL 2000 all db sizes

    maybe this is to much but getting the dbname in the ouput as well?
  5. patrick118

    SQL 2000 all db sizes

    Thank you. Completely solved the problem regards Patrick
  6. patrick118

    SQL 2000 all db sizes

    I want a list of all databases and there db sizes in 1 query but i get the problem that i need to login into each database to get the right information. In the query below it goes wroing when i try to login another database. Could you help me get the answer or give another script? declare...
  7. patrick118

    don't get dhcp lease

    I installed the vmware player on windows XP. When I look at the networks i got 2 extra networks installed VMWARE Network adapter VMNET1 en 8 They both are DHCP lease but when i refresh my addresses they keep getting a range that is not on my network 192.168.92.1 and 192.168.109.1 they say...
  8. patrick118

    RMAN tool

    Not a very urgent question but does anyone know of a rman tool. Perhaps some shell over the oracle rman tool. Syntax checking etc. I can't seem to find one.
  9. patrick118

    system uptime

    THANX
  10. patrick118

    system uptime

    I got the following out of the scriptcentre strComputer = "." Set objWMIService = GetObject _ ("winmgmts:\\" & strComputer & "\root\cimv2") Set colOperatingSystems = objWMIService.ExecQuery _ ("Select * from Win32_OperatingSystem") For Each objOS in colOperatingSystems dtmBootup =...
  11. patrick118

    recover tablespace until

    I allready thought that would be the answer i get. Thank you for answering. Well back to the studybooks and look at TSPITR
  12. patrick118

    recover tablespace until

    I'm testing a few things with recovery. I have a database 9.2 in archivelog mode. I made a cold backup of the entire database started the database and made some changes to the table in tablespace example. scn is now 55770 made some more changes and scn is now 55980 I set the tablespace...
  13. patrick118

    local system logon as sysdba

    no
  14. patrick118

    local system logon as sysdba

    I realize that and that is "sort" of the problem this is an internal windows account that you can't grant such rights to. But thank you for the post
  15. patrick118

    local system logon as sysdba

    I have a batch job like the following sqlplus /nolog @start.sql in the start.sql script it sys the following connect / as sysdba When i start it as an administrator works ok. When i schedule it it is automatically started as local system and then i get insufficient priviliges. I don't want to...
See more

Part and Inventory Search

Back
Top