User contributions
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)
- 20:48, 6 December 2011 (diff | hist) . . (+246) . . N How to use more than 9 parameters in a DOS/Windows batch file (Created page with "From: D:\ORACLE\Middleware\oms11g\BIN\orapipe.bat Look at emcli.bat for expert stuff @echo off set xdkparm= :loop if "%1"=="" goto end set xdkparm=%xdkparm% %1 shift go...") (current)
- 20:36, 6 December 2011 (diff | hist) . . (+295) . . Extract ddl with "dbms metadata.get ddl"
- 20:32, 6 December 2011 (diff | hist) . . (+379) . . Extract ddl with "dbms metadata.get ddl"
- 20:28, 6 December 2011 (diff | hist) . . (+1) . . Extract ddl with "dbms metadata.get ddl"
- 20:28, 6 December 2011 (diff | hist) . . (+312) . . N Extract ddl with "dbms metadata.get ddl" (Created page with " set pagesize 0 set linesize 30000 set long 500000 set longchunksize 500000 set trimspool on set feed off select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||...")
- 20:13, 6 December 2011 (diff | hist) . . (-24) . . Recent errors in database alert log (current)
- 20:12, 6 December 2011 (diff | hist) . . (+52) . . Recent errors in database alert log
- 20:10, 6 December 2011 (diff | hist) . . (+535) . . N Recent errors in database alert log (Created page with " #!/bin/ksh printf "Enter Destination File: " read dest files="/*/u??/oradata/$ORACLE_SID/oralogs -name alert_$ORACLE_SID.log" for file in $(find $files) do DT=$(date) ...")
- 19:43, 6 December 2011 (diff | hist) . . (+4,387) . . N Restore SQL Server database (Created page with "* First copy the dump from \\spifls07.mon.local\DATA.1013\01_DBdumps\SQL\ to the target SQL Server in ONT * Check the current security settings on the ONT database, use this scri...")
- 19:40, 6 December 2011 (diff | hist) . . (-28) . . Recompile invalid objects (→Recompile invalid objects) (current)
- 19:34, 6 December 2011 (diff | hist) . . (+248) . . N Recompile invalid objects (Created page with "==Recompile invalid objects== *Connect to an Oracle database as user sys *Check to see how many objects are invalid: select count('e') from dba_objects where status='INVALID...")
- 19:43, 1 December 2011 (diff | hist) . . (+53) . . WebLogic Server reports "target has encountered metric evaluation errors" in Grid (current)
- 19:42, 1 December 2011 (diff | hist) . . (+24) . . WebLogic Server reports "target has encountered metric evaluation errors" in Grid
- 19:39, 1 December 2011 (diff | hist) . . (+13) . . WebLogic Server reports "target has encountered metric evaluation errors" in Grid
- 19:30, 1 December 2011 (diff | hist) . . (+2,291) . . N WebLogic Server reports "target has encountered metric evaluation errors" in Grid (Created page with "'''Problem'''<br /> The WLS targets report having metric evaluation errors and the agent log files are full of errors (and filling up rapidly) '''Diagnosis''' *Check the logfil...")
- 14:50, 1 December 2011 (diff | hist) . . (+211) . . Delete a database on Windows
- 14:45, 1 December 2011 (diff | hist) . . (0) . . Delete a database on Windows
- 14:45, 1 December 2011 (diff | hist) . . (+81) . . Delete a database on Windows
- 14:34, 1 December 2011 (diff | hist) . . (+540) . . N Delete a database on Windows (Created page with "*Check where the ORACLE_HOME for this instance is: Start:Run... services.msc Double click on OracleService<SID>, the first part of "Path to executable" is the home *Find locati...")
- 22:41, 30 November 2011 (diff | hist) . . (+153) . . (Re)create user/schema using DataPump
- 20:02, 30 November 2011 (diff | hist) . . (+9) . . (Re)create user/schema using DataPump
- 20:00, 30 November 2011 (diff | hist) . . (+620) . . N (Re)create user/schema using DataPump (Created page with "If the user does not yet exist on the destination database, just import it using the procedure outlined here. If however, the user already exists and the grants are differen...")
- 15:52, 30 November 2011 (diff | hist) . . (+1,417) . . N Clever use of pipes for saving space during import and export (Created page with "Not enough disk space for the "expdat.dmp" file? Here is a useful 'how-to' to demonstrate the use of pipes: #!/bin/ksh # Export with flags (full, consistent) to a compressed f...")
- 15:44, 30 November 2011 (diff | hist) . . (-1) . . Flashback query with database in noarchivelog mode (current)
- 15:43, 30 November 2011 (diff | hist) . . (+5) . . Flashback query with database in noarchivelog mode
- 15:43, 30 November 2011 (diff | hist) . . (-1) . . Flashback query with database in noarchivelog mode
- 15:42, 30 November 2011 (diff | hist) . . (+8) . . Flashback query with database in noarchivelog mode
- 15:39, 30 November 2011 (diff | hist) . . (+2) . . Flashback query with database in noarchivelog mode
- 15:39, 30 November 2011 (diff | hist) . . (+560) . . N Flashback query with database in noarchivelog mode (Created page with "Typically, development databases are not started in archivelog mode. This causes a problem for hot backups but not necessarily for flashback queries. You can still flashback to a...")
- 14:44, 30 November 2011 (diff | hist) . . (+354) . . N SQL*Plus connection without using tnsnames.ora (Created page with "No access to tnsnames.ora or just a temporary database and don't want to add the connection to the tnsnames.ora file? Connect direct using this syntax (equivalent to the "Direc...") (current)
- 19:37, 28 November 2011 (diff | hist) . . (-12) . . Datapump
- 19:36, 28 November 2011 (diff | hist) . . (+89) . . Datapump
- 19:29, 28 November 2011 (diff | hist) . . (+1) . . Datapump (→Use the flashback parameter to export and import a consitent dump)
- 19:28, 28 November 2011 (diff | hist) . . (+432) . . N Datapump (Created page with "==Use the flashback parameter to export and import a consitent dump== expdp <user>/<pwd> parfile=db_params.par where db_params.par would look like this: flashback_time=sysdat...")
- 19:15, 28 November 2011 (diff | hist) . . (+23) . . N Backup and Recovery (Created page with "*RMAN *DataPump")
- 19:15, 28 November 2011 (diff | hist) . . (+15) . . Main Page
- 19:13, 28 November 2011 (diff | hist) . . (+19) . . Main Page
- 19:12, 28 November 2011 (diff | hist) . . (+2) . . Main Page
- 19:12, 28 November 2011 (diff | hist) . . (+51) . . Main Page
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)
