-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Here are some of the scenarios when one gets ORA-01031: 1) Insufficient privileges error is when “oracle” user is not… READ MORE
|
There are few ways to change case of text in a file from lower case to upper case or vice-versa.… READ MORE
|
When you are copying oracle files (datafiles, archivelogs, controlfiles, etc) or any binary file one can compare if the files… READ MORE
|
Using chsh one can change their login shell. To show the shells that are available $ chsh -l /bin/sh /bin/bash… READ MORE
|
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
“Control what I can control”
~ Alex Lima
Alex Lima 