Convert CLOB to BLOB I will write a procedure clob_blob_proc which convert description column of test table of type clob to blob. Here is the procedure. ... ...
How to configure(modify,see) Kernel Parameters in Linux Kernel Parameters, Recommended Values to install Oracle and Associated Files 1)semmsl semmns semopm...
How to change the hostname in Linux There are several ways by which we can change the hostname in linux. The process may vary based on distribution of linux. ...
How to load data using external table into oracle database Using SQL*Loader we can load data from flat data file to oracle database which is described in How...
How to Create and Use OMF OMF indicates Oracle Managed Files. With the use of Oracle-managed files the administration of an Oracle Database can be simplified. ...
How to Find out or Check Linux Version Information Before installing oracle clusterware it is necessary in which version of linux you are trying to install to....
Possible Limitations When Adding Datafiles to a Tablespace Before discussing limitations of adding datafiles to a tablespace let's think about DB_FILES...
Running Runinstaller fails with DISPLAY not set When I running the runinstaller command on my linux server after entering through ssh it fails with DISPLAY not...
ORA-12560: TNS:protocol adapter error on windows machine while starting oracle Error Description On my windows server machine whenever I try to logon to...
Recover database after missing online redo logs and all controlfiles. This example is based on, You have lost all your current and backup of controlfiles. You...
How to restore an Spfile from autobackup older than 7 days Whenever we issue in RMAN, RMAN> restore spfile from autobackup; then restoring from autobackup...
What will happen if oracle unable to write Alertlog, Core Dump Or Tracefiles In this I will show what can happen if Oracle is unable to write to the ...
How to avoid of recreating pfile or spfile if any error in spfile Let us some talk about pfile and spfile. Suppose I have done some wrong-edit inside spfile...
Why create between pfile and spfile works if shutdown database Sometimes it may arises question that while database is shutdown then you can still connect to...
How to find Top Sql through Queries If someone ask for top sql they from enterprise manager he can find some expensive queries. But the result may vary based...
How to find Top Sql through Queries If someone ask for top sql they from enterprise manager he can find some expensive queries. But the result may vary based...
Create Read only user for a Schema One thing you need to remember before read this post is there is no easy or shortcut way to make a read only user of another...
Drop Temporary Tablespace Hangs Problem Description The DROP temporary tablespace operations take long time and in fact it hangs. If you take a 10046 trace of...
Minimum privilege needed to take data pump export In your organization you may assign a user who is only responsible to take data pump export. Suppose everyday...
EM Daemon is not running On windows whenever I try to start my dbconsole in one time during process it shows me message EM Daemon is not running. Details in...
How to recover or recreate temporary tablespace in 10g In database you may discover that your temporary tablespace is deleted from OS or it might got...
How to clone database on the same host with different name In this post I will show how we can clone database on windows system without using RMAN duplicate....
List of Patchset number in metalink You want to download patchset from metalink but you don't know the patchset number. In that case it may take some moments...
RMAN-00554,RMAN-04005,ORA-0103 when remote connection by rman Whenever I try to connect remotely to a database through rman it fails with message RMAN-00554,...
How to know whether I use analyze or DBMS_STATS Automatic statistics gathering should be sufficient for most of the cases. And automatic statistics gathering...
How to take RMAN backup on a remote disk It is common to hear that for backup there is not sufficient space on my server or my server disk is about to full....
Automatic startup and shutdown oracle on linux Oracle database server provides two scripts to configure automatic database startup and shutdown process. The...
How to generate fibonacci series in Oracle. Way 1: with data as (select level levels from dual connect by level <= &how_may_rows) select f from data model...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
