Archive for September, 2019

CONSTANTINES REAL PLAN

September 29th, 2019, posted in Batman
Share

batman and john constantine, batman and john constantine comic, batman john constantine comic, constantine, hates john constantine, john constantine, john constantine comic, Justice League, Justice League constantine, Justice League Dark, Justice League john constantine,

batman and john constantine, batman and john constantine comic, batman john constantine comic, constantine, hates john constantine, john constantine, john constantine comic, Justice League, Justice League constantine, Justice League Dark, Justice League john constantine,

Share

WHY ROSE CONSTANTINE IS SPECIAL

September 24th, 2019, posted in Batman
Share

john constantine comic, constantine, hates john constantine, john constantine, john constantine comic, Justice League, Justice League constantine, Justice League Dark, Justice League john constantine,

Share

Renaming Data Files in 11g database

September 22nd, 2019, posted in Oracle Queries
Share

Renaming datafile (.dbf) rename in 11g

 

Rename Datafiles in Single Tablespace (Database Open Mode) :

Caution : Backup your tablespace Before you will do some change in your tablespace.

Please find below steps to rename datafile.

We can use the alter tablespace rename datafile command,
but the tablespace most be offline and you must re-name at OS level command the data file while the tablespace is offline:

Step: 1

[ora@oracle ~]$ sqlplus / as sysdba

SQL> ALTER TABLESPACE SYSAUX OFFLINE NORMAL;
Tablespace altered.

SQL> !



Step: 2

Rename undo07.dbf to sysaux08.dbf

[ora@oracle ~]$ cd /u01/db/apps_st/data/

[ora@oracle data]$ ls -lrt|grep undo07.dbf
-rw-r----- 1 oraqa dba 3221233664 Aug 9 11:32 undo07.dbf

[ora@oracle data]$ chmod 755 undo07.dbf

[ora@oracle data]$ mv undo07.dbf sysaux08.dbf

[ora@oracle data]$ ls -lrt|grep undo07.dbf

[ora@oracle data]$ ls -lrt|grep sysaux08.dbf
-rwxr-xr-x 1 oraqa dba 3221233664 Aug 9 11:32 sysaux08.dbf


Step: 3

[ora@oracle data]$ sqlplus / as sysdba

SQL> ALTER TABLESPACE SYSAUX RENAME DATAFILE '/u01/db/apps_st/data/undo07.dbf' to '/u01/db/apps_st/data/sysaux08.dbf';

Tablespace altered.



Step: 4

SQL> ALTER TABLESPACE SYSAUX ONLINE;

Tablespace altered.


Steps: 5

Verify tablespace status.

SQL> SELECT status
FROM dba_tablespaces
WHERE tablespace_name = 'SYSAUX';

STATUS
---------
ONLINE

Verify datafile name.

SQL> select TABLESPACE_NAME,FILE_NAME from dba_data_files where TABLESPACE_NAME = 'SYSAUX';

TABLESPACE_NAME-------------FILE_NAME
--------------------------------------------------------------------------------
SYSAUX /u01/db/apps_st/data/sysaux08.dbf

 

Rename datafile undo07.dbf to sysaux08.dbf completed.

Share

If I Die Of This Stroke Of His Kill Him With One Similar Stroke

September 19th, 2019, posted in Saying Of Hazrat Ali ( A.S ), Saying Of Holy Prophet ( P.B.U.H)
Share

By Imam Ali, Will By Imam Ali, Hazrat Ali, Imam Ali, islam, islamic Quote, islamic Quote Saying, islamic Quotes, islamic Quotes Sayings, islamic Saying, islamic Sayings, islamic teaching, islamic teachings, Saying.jpg, sayings, Sayings of Hazrat Ali, sayings of Imam Ali,Last Will Of Hazrat Ali

Share

BATMAN AND CONSTANTINE BONDS

September 17th, 2019, posted in Batman
Share

Share