-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
Jobs can be scheduled couple of ways on unix like cron, at. Below is description how jobs can be scheduled… READ MORE
|
DECLARE @role_name VARCHAR(100) DECLARE @member_name VARCHAR(100) DECLARE @rolescur CURSOR DECLARE @rolememberscur CURSOR DECLARE @loginname VARCHAR(100) DECLARE @username VARCHAR(100) DECLARE @logincur… READ MORE
If one needs to restore archive logs to disk and not apply them, for example in case when cloning a… READ MORE
|
# Using ls and sort one can sort the files by their size, here is what the options means #… READ MORE
In 10g there is a new view called DBA_FEATURE_USAGE_STATISTICS which keeps features have been used. Here is description of some… READ MORE
NLS_CHARACTERSET is used for CHAR, VARCHAR2, CLOB columns and NLS_NCHAR_CHARACTERSET is used for NCHAR, NVARCHAR2, NCLOB columns. One can find… READ MORE
|
There are few commands one can use to save a file n To save and quit: <esc>:wq To save (if… READ MORE
|
The view DBA_ROLES doesn’t have the created date column to display when the role was created, but the information is… READ MORE
This script will delete files modified more than 14 days ago and have file name that begin with daily_backup ,… READ MORE
|
Useful commands in vi: To delete lines One at a time: <esc>dd n lines at a time: <esc>ndd – where… READ MORE
This parameter controls the format of the archive log file name. This parameter can’t be changed on the fly therefore… READ MORE
Using the following steps one can clone a database manually. In the following example PRD represents the source and DEV… READ MORE
—– Connect.java —- —- To compile c:> javac Connect.java —- Note: Make sure the CLASSPATH env is set. MySQL Connnector/J… READ MORE
|
If you use SSH to login using your own user account and su to oracle or su directly to oracle… READ MORE
Tom Kyte, Oracle DBA and founder of the Ask Tom blog, gave the Oracle Database Insider his resolutions for 2009… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 