-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
General Database Script
— view oracle internal parameters, note this can be run by SYS user — name, value, default value, session modifiable,… READ MORE
Here is a simple script to extract the DB Links DDL with the encripted password. SET LONG 9000 — to… READ MORE
|
The following can be used to create a script for DB Links with work on 8i/9i and will contain the… READ MORE
|
One can’t move the temp tablespace during mount stage like other datafiles using “ALTER DATABASE RENAME FILE..” so a workaround… READ MORE
Get current total TEMP tablespace currently allocated, used and free: SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024… READ MORE
Here is a nice script if you need to move your datafiles to a new location. SQL>spool rename_datafile.sql set line… READ MORE
|
set serveroutput on set serveroutput on size 1000000 DECLARE vcount1 number := 0; vcount2 number := 0; v_tablename varchar2(32); v_viewname… READ MORE
|
This simple script will check if a user password is expiring in the next 120 days. set pagesize 500 set… READ MORE
|
— Print # of archive logs for yesterday by the hour — can be used to determine to schedule archive… READ MORE
|
We have faced a situation where replication with materialized view needs to be checked before the shutdown outage between source… READ MORE
|
Sometimes you want to check for datafiles with the same name in the database, maybe you are new to the… READ MORE
|
A lot of people actually ask me why sql*plus doesn’t have a help feature like man in UNIX. Actually it… READ MORE
|
There are some cool SQL*PLUS command to help speed up your typing. Today I am showing the change and append… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 