Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | Questions | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums
Online Tools:  Generate rename / copy datafiles script

 
 
 
 Found 13 tips, Displaying 11 - 13 
 
Sort by 
 
 Generate a script to unbreak / break Oracle jobs
-- -- Generate a script to unbreak jobs for a schema -- Replace USERNAME with schema owner and PASSWORD with schema owner's password -- -- To break the jobs replace: -- spool unbreak_jobs.sql -> spool break_jobs.sql -- broken=>FALSE -> broken=>TRUE -- where broken = 'Y' -> where broken = 'N' -- set echo off verify off feedback off ...
 More...
10/03/05
 
 
 Kill user session
Use this procedure to find and kill a user's session: SQLPLUS> select sid, serial# from v$session where username = 'USER'; SQLPLUS> alter system kill session 'SID,SERIAL#';
     
More...

10/03/05
 
 
 Reset DBID
Reset database id so that it can be backed up if the same DBID already exists in RMAN catalog for a different database. SVRMGR> alter database backup controlfile to trace resetlogs; SVRMGR> shutdown immediate; SVRMGR> startup mount; SVRMGR> select dbid , name from v$database ; DBID NAME ---------- --------- 673658548 ...
 More...
09/23/05
 
 

<< 1 | Page 2

Recent tips & tricks
Miscellaneous > Middleware > Oracle Fusion Middleware > Oracle SOA Suite : Cannot connect to database whe...
Databases > Oracle : How to identify semaphors and ...
Databases > Oracle > Oracle 10g : How to drop tablespace with da...
Databases > Oracle : How to move an index to anothe...

More categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Office Software | TipLib FAQ
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com