Oracle & Linux Blog

ORADIM is a command-line tool that is available with Oracle Database. You are required to use ORADIM only if you are manually creating, deleting, or modifying databases. Oracle Database Configuration Assistant is an easier tool to use for this purpose. Starting with Oracle Database 12 c  Release 1 (12.1), ORADIM creates Oracle Database service, Oracle VSS Writer service, and Oracle Scheduler service to run under the Oracle Home User account. If this account is a Windows Local User Account or Windows Domain User Account, then ORADIM prompts for password for that account and accepts the same through  stdin . It is possible to specify both the Oracle Home User and its password using the  -RUNAS osusr[/ospass]  option to  oradim . If the given  osusr  is different from the Oracle Home User, then the Oracle Home User is used instead of  osusr  along with the given  ospass . The following sections describe ORADIM commands and paramet...

Flashback database offer a simple way for performing a point in time recovery. This feature was introduced in oracle 10g. Let’s take a scenario, where we have generated huge amount of flashback logs. Now to reclaim the space, we can reduce the db_flashback_retention_target parameter to a very small value, which will make the logs obsolete after some time & will delete them in case of space pressure in FRA (Flash / Fast Recovery Area). But if we want to reclaim the space immediately, we can trun off the flashback. In 10g we’ll have to shutdown immediate startup mount alter database flashback off; alter database open; But with 11gR2, Oracle introduced a new feature. We can now turn flashback on / off, when database is OPEN SQL> select * from v$version; BANNER ------------------------------ ------------------------ Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS ...

Imran> select * from student;         Sno ----------       1   2 3 Imran> select xmlagg (xmlelement (e,Sno ||',')).EXTRACT('//text()') as Sno from (select distinct Sno from student);   Sno -------------------------------------------------------------------------------------------------------------------------- 1,2,3, If we observe the above result it contains comma(,) at the end. In order to remove comma(,) we will use RTRIM function: Imran> select rtrim(xmlagg (xmlelement (e,Sno ||',')).EXTRACT('//text()'), ',') as Sno from (select distinct Sno from student); Sno ------------------------------------------------------------------------------------------------------------------------- 1 ,2,3