You are here:   Home
Oct
19
2010
Why there is a diff btwen DBA_SEGMENTS & DATAPUMP of particular schema size
Why there is a difference between DBA_SEGMENTS & DataPUMP of size of particular schema
======================================================================================

1
Read more...
 
Oct
19
2010
How to change the characterset of Oracle 10g DB
Decide the character set you want to change and check whether new character is superset of old character set

1.SQL> shutdown immediate
2.SQL> startup open restrict
3.SQL> alter database character set internal_use UTF8;
4.SQL> shutdown immediate
5.SQL> startup

Refer the following Metalink Note for more details:

Note 225912.1 Changing the Database Character Set - a short overview
Note 227330.1 Character Sets & Conversion - Frequently Asked Questions
Read more...
 
Oct
19
2010
RMAN Backup Validation Check
To Test and Check the Integrity for Backups
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

The database prevents operations that result in unusable backup files or corrupt restored datafiles
Read more...
 
Oct
19
2010
Query to find All Background_processes in the Database
Background Processes

Background processes support various types of Oracle processing

Each version of Oracle has a set of associated background processes
Read more...
 
Oct
19
2010
how to change expired status of user accounts.txt
SQL> select username,account_status from dba_users where username='DIP';

USERNAME ACCOUNT_STATUS
----------------------- ---------------
SCOTT EXPIRED & LOCKED


SQL> alter user SCOTT account unlock;

User altered.

SQL> select username,account_status from dba_users where username='SCOTT';

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SCOTT EXPIRED

SQL> select password from dba_users where username='SCOTT';

PASSWORD
------------------------------
CE4A36B8E06CA59C

SQL> alter user scott identified by values 'CE4A36B8E06CA59C';

User altered.

SQL> select username,account_status from dba_users where username='SCOTT';

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SCOTT OPEN
Read more...
 
Oct
19
2010
Difference Between AFN & RFN
RELATIVE FILE NO.

Relative file no is the file no
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Follow Me