Posts

Showing posts from October, 2014

Applying “version 4″ Time Zone Files on an Oracle Database

Applying “version 4″ Time Zone Files on an Oracle Database Applying “version 4″ Time Zone Files on an Oracle Database if your timezone file version is less than 4 Yesterday I was upgrading the database form 10.2.0.3 to 10.2.0.5 on RHEL 5, In readme of the 10.2.0.5 patch i came across the timezoe files, We need to upgarde the timezone files of the base database to 4, is minimum requirement. I found my timezone files 3, you can use following query to find the timezone of the database : SQL> select * from v$timezone_file; FILENAME        VERSION ------------ ---------- timezlrg.dat          3   If  your database versions are 9.2.0.8 & 10.2.0.4,your  timezone file version will be 4 by default, upgrading to 11.1.0.6.0  or 11.2.0.1.0 we need timezone version 4, If your database is 9.2.0.7, we need to upgarde it to 9.2.0.8  or database versions are 10.2.0.1, 10.2.0.2, 10.2....

IMPDP TABLE_EXISTS_ACTION = APPEND, REPLACE, [SKIP] and TRUNCATE

  IMPDP  TABLE_EXISTS_ACTION PARAMETER EXPLAINED  Data Pump IMPDP TABLE_EXISTS_ACTION = APPEND, REPLACE, [SKIP] and TRUNCATE In conventional import utility (IMP) we have ignore =y option which will ignore the error when the object is already exist with the same name. When it comes to the data pump there is one enhanced option of ignore=y which is called TABLE_EXISTS_ACTION. The values for this parameter give 4 different options to handle the existing table and data. $ impdp help=y     TABLE_EXISTS_ACTION     Action to take if imported object already exists.     Valid keywords are: APPEND , REPLACE , [ SKIP ] and TRUNCATE .     SKIP : Default value for this parameter is SKIP. This parameter is exactly same as the IGNORE=Y option in conventional import utility.     APPEND : This option appends the data from the data dump. The extra rows in the dump will be appended to the table and the existing dat...

Svn client error svn: E160006: Invalid revision number '-1'

Topic : svn: E160006: Invalid revision number '-1'  I have recently come across this error when I installed the svn client on my machine. I have the latest version of tortoise svn client on my local machine. After install I used to get this weird error when ever I used to do check out.   Unexpected HTTP status 500 'Server Error' on  '/scm/svn/database/releases/!svn/vcc/default' Additional errors: svn: E160006: Invalid revision number '-1'  I goggled a lot but nothing seems to work. Finally I figured out. The client and server versions are not same then I downloaded the same version of the tortoise client as of server. Then it seemed to work fine. Conclusion : Try to download the tortoise svn of same version as of server and it seems to work fine without any problem.