Wednesday, 6 June 2012

SQLPLUS OPTIONS

›
sqlplus options:- 1. sqlplus /nolog : Starts SQL*Plus but does not log on (connect) a user/session. C:\>sqlpl...
1 comment:
Saturday, 2 June 2012

Difference between SYSDBA and SYSOPER:-

›
Difference between SYSDBA and SYSOPER:- SYSOPER:- SYSOPER privilege allows operations such as:          Instance startup, ...
1 comment:
Friday, 9 September 2011

How to change SYSMAN user password in 11gr1 on linux (oracle enterprise respository)

›
Changing SYSMAN user password. OS Linux Oracle 11gr1 Steps: 1. stop oem services 2. check db control is stopped 3. connect to the databa...

How to Migrate From Database File system to ASM | Managing Database in ASM

›
TO Migrate the database files from disk to asm disk is as follows, 1.configure flash recovery area. 2.Migrate datafiles to ASM. 3.Contro...

Converting Single instance to RAC instance Database Using DBCA

›
T here are different ways to convert a single instance database to RAC. 1) Manual Method 2) Using rconfig 3) Using DBCA 4) Using grid contr...
Tuesday, 2 August 2011

SQL Loader

›
SQL LOADER utility is used to load data from other data source into Oracle. For example, if you have a table in FOXPRO, ACCESS or SYBASE ...
1 comment:
Monday, 4 July 2011

How to find out oracle databases present in system|how to log in as DBA in any database by command prompt

›
Hello friends,This is out first tutorial on basic oracle. Here we will study how to find out which oracle databses are present in out syste...