hakkialsaidi.blogspot.com
Hakki Al Saidi حقي الساعدي: May 2012
http://hakkialsaidi.blogspot.com/2012_05_01_archive.html
Hakki Al Saidi حقي الساعدي. Monday, May 21, 2012. How to count number of files in a directory in Linux. Ls -1 targetdir wc -l. Links to this post. Saturday, May 19, 2012. Listing invalid indexes in Oracle. SELECT TABLE OWNER,TABLE NAME,OWNER,INDEX NAME,INDEX TYPE,STATUS,. FROM all indexes WHERE owner NOT IN ('SYS', 'SYSTEM'). OR index name IN(SELECT index name. FROM all ind partitions. N/A' OR index name IN ( SELECT index name. FROM all ind subpartitions. USABLE' ) ) ;. Links to this post. Wait events us...
hakkialsaidi.blogspot.com
Hakki Al Saidi حقي الساعدي: June 2014
http://hakkialsaidi.blogspot.com/2014_06_01_archive.html
Hakki Al Saidi حقي الساعدي. Monday, June 9, 2014. RESTORE TABLE FROM RMAN BACKUP ORACLE12c database. The RECOVER TABLE command is a new feature in 12C that allows point in time recovery of a table or a table partition. The table is recovered into an auxiliary instance and there is the option to:. Import the recovered table into a new table or partition using REMAP option. Create the expdp dump of the recovered table only, for import at a later time of your choosing. RECOVER TABLE "SCOTT"."EMP". UNTIL SEQ...
hakkialsaidi.blogspot.com
Hakki Al Saidi حقي الساعدي: July 2012
http://hakkialsaidi.blogspot.com/2012_07_01_archive.html
Hakki Al Saidi حقي الساعدي. Wednesday, July 18, 2012. How to change database character set. This article gives a overview of methods to change the database character set . Change Oracle Database Character Set : NLS CHARACTERSET. The syntax of the ALTER DATABASE CHARACTER SET statement is as follows:. ALTER DATABASE db name CHARACTER SET new character set;. Db name is optional. The character set name should be specified without quotes. For example:. ALTER DATABASE CHARACTER SET AL32UTF8;. 4 STARTUP MOUNT;.
hakkialsaidi.blogspot.com
Hakki Al Saidi حقي الساعدي: RESTORE TABLE FROM RMAN BACKUP ORACLE12c database
http://hakkialsaidi.blogspot.com/2014/06/restore-table-from-rman-backup.html
Hakki Al Saidi حقي الساعدي. Monday, June 9, 2014. RESTORE TABLE FROM RMAN BACKUP ORACLE12c database. The RECOVER TABLE command is a new feature in 12C that allows point in time recovery of a table or a table partition. The table is recovered into an auxiliary instance and there is the option to:. Import the recovered table into a new table or partition using REMAP option. Create the expdp dump of the recovered table only, for import at a later time of your choosing. RECOVER TABLE "SCOTT"."EMP". UNTIL SEQ...
hakkialsaidi.blogspot.com
Hakki Al Saidi حقي الساعدي: October 2011
http://hakkialsaidi.blogspot.com/2011_10_01_archive.html
Hakki Al Saidi حقي الساعدي. Monday, October 31, 2011. How to check how much disk space is allocated/ in-use by an ASM instance? Login to your ASM instance (SYS AS SYSDBA) and execute the following query:. SQL COL % FORMAT 99.0 SQL SELECT name, free mb, total mb, free mb/total mb*100 "%" FROM v$asm diskgroup; NAME FREE MB TOTAL MB % - - - - - - - - - - - - - - - - - - - - - - - - - - - - DATA 917104 1482145 61.9 RECOVER 17387 17437 99.7. From Oracle 10g Release 2, one can also use the asmcmd. To remove a ...
hakkialsaidi.blogspot.com
Hakki Al Saidi حقي الساعدي: December 2011
http://hakkialsaidi.blogspot.com/2011_12_01_archive.html
Hakki Al Saidi حقي الساعدي. Friday, December 23, 2011. Troubleshoot invalid objects in Oracle. Most of the procedural objects like procedures, functions, triggers, objects refer to data objects, such as table. If the code refers to a column, the column must exist or the code will not compile. If any of the data objects to which a procedural object refers change after the procedural object has been compiled, then the procedure will be marked INVALID. Programmer made a simple syntactical mistake. 2)If comp...
hakkialsaidi.blogspot.com
Hakki Al Saidi حقي الساعدي: January 2013
http://hakkialsaidi.blogspot.com/2013_01_01_archive.html
Hakki Al Saidi حقي الساعدي. Thursday, January 10, 2013. ORA-24248 XMLDB extensible security not installed. ORA-24248 XMLDB extensible security not installed. Please see: Oracle 11g Access Control List for External Network Services. A few days ago I ran into this problem. We upgraded one of our development database from oracle 10gR2 to 11gR1 recently. After the upgrade the application was broken very badly. Any user trying to login to the application was getting the error below:. ORA-06512: at line 1.
hakkialsaidi.blogspot.com
Hakki Al Saidi حقي الساعدي: February 2011
http://hakkialsaidi.blogspot.com/2011_02_01_archive.html
Hakki Al Saidi حقي الساعدي. Wednesday, February 23, 2011. Metadata processing is not available. ORA-39213: Metadata processing is not available. Cause: The Data Pump could not use the Metadata API. Typically, this is caused by the XSL stylesheets not being set up properly. Connect AS SYSDBA and execute dbms metadata util.load stylesheets. To reload the stylesheets. Links to this post. Labels: Metadata processing is not available. Monday, February 7, 2011. Identify the Session to be Killed. The SID and SE...
hakkialsaidi.blogspot.com
Hakki Al Saidi حقي الساعدي: January 2012
http://hakkialsaidi.blogspot.com/2012_01_01_archive.html
Hakki Al Saidi حقي الساعدي. Monday, January 30, 2012. Day of the Week (range: 1-7, 1 standing for Monday). Month of the Year (range: 1-12). Day of the Month (range: 1-31). Links to this post. Tuesday, January 10, 2012. Find duplicate rows in a table. Links to this post. Subscribe to: Posts (Atom). View my complete profile. Some of the blog's are copy and the other from me the aim is the benefit for all. Find duplicate rows in a table. How to send email from 11g Oracle Database (UTL MAIL).