Visit http://arjudba.blogspot.com/2008/04/types-of-metadata-views-in-oracle-10g.html Types of Metadata Views in Oracle 10g Metadata indicates data about the...
LONG Datatype in Oracle •Before going into detail oracle strongly recommend not to use LONG datatype in oracle. LONG datatype is remained for backward ...
Creating Multiple Tables and Views in a Single Operation Sometimes you may need to do several ddl statements in a database.Suppose in a file you have list of...
Schema Object Naming Rules In order to know the schema objects please have a look at http://arjudba.blogspot.com/2008/06/database-objects-in-oracle.html There...
New Feature of 10.2g: Eliminate Control File Re-Creation Before Oracle 10.2g if we need to change the limit of MAXLOGFILE, MAXLOGMEMBERS, MAXLOGHISTORY,...
ORA-01756: quoted string not properly terminated ... Single quote within a string data type like CHAR, VARCHAR2, NVARCHAR etc. will end up during runtime with...
... Whenever you run any procedures or functions or any other application or transaction either database level or application level you get the following...
Null value Concept in Oracle •A column in a row contains Null value in oracle is treated as special one which indicates the column in that row contains no...
What is the difference between @ and @@ in Sql*plus? From Sql*plus we can execute any script with START command. @ is similar to START. If you write...
Solution of ORA-28002: the password will expire within 10 days ... Whenever a user try to connect to database it raise ORA-28002: error. -bash-3.00$ sqlplus...
Can I get an idea when a row is created (ORA_ROWSCN Pseudocolumn) To know the exact time of when a row is inserted or updated or deleted you have to use audit...
General Windows Keyboard Shortcuts We all are too familiar to use mouse specially those who work on windows machine. Along with mouse there are some kyboard...
Internet Explorer Keyboard Shortcuts 1)F1: Display Internet Explorer help context. 2)F11: Switch between full screen view and other view of Internet Explorer....
Hey, Did you hear about Scour? It is the next gen search engine with Google/Yahoo/MSN results and user comments all on one page. Best of all we get paid for...
How to Load or copy data from SQL Server or excel to Oracle If you want any software and automatic conversion to migrate non oracle database to oracle then you...
More Internet Explorer Keyboard Shortcuts Shortcuts to Access Address Box Note that if internet explorer's tab are enabled then for only the first tab these ...
Archiving not possible: No primary destinations Error Description: Today I got a very interesting problem. The developer told me that they can't connect to...
How to Change the iSQL*Plus Port 1)Stop the iSQL*Plus. bash-3.00$ isqlplusctl stop iSQL*Plus 10.2.0.1.0 Copyright (c) 2003, 2005, Oracle. All rights reserved....
How to Identify OS or Oracle 64 bit or 32 bit on Unix It is very common question which version of oracle I need to install. 32 bit or 64 bit? As a 64-bit...
New Feature of 10.2g: Eliminate Control File Re-Creation Before Oracle 10.2g if we need to change the limit of MAXLOGFILE, MAXLOGMEMBERS, MAXLOGHISTORY,...
ORA-01667: cannot add any more tablespaces: limit of exceeded If your database version is 10.2g then your control file MAXDATAFILES parameter would expand...
How to use Oracle Logminer to analysis Logfile We know that any changes to database is recored in online redo logfiles. If your database archival mode on then...
Difference between V$parameter and v$spparameter V$PARAMETER It displays the information about initialization parameters that are currently in effect for the...
How to know database initialization parameter in oracle 1)SHOW PARAMETER option: If you use SQL*Plus then you can use SHOW PARAMETER parameter_name to display ...
How to monitor alert log file in Oracle We know in a UNIX system with tail -f we can monitor alert log file to see how alert log file is populated. For example...
How to Schedule or Automate Backup through Crontab Schedule or Automate Backup is a needed thing almost in all environment. We can do automate or scheduling...
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...
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.
