Articles Comments

AskDba.org Weblog » Archive for January 2009

Input is too long (> 2499 characters) – line ignored

January 30th, 2009 | Add a Comment

There are times when you observe above mentioned error while creating view and mview from mview definition taken from Toad or indexfile option. vi editor comes in handy to resolve this issue. Copy the code in Text file and while in escape mode enter following command :%s/,/,^M/g Please note that to insert ^M you need to press Ctrl+V+M keys together.We are basically using the command to enter a line break after each comma.  … Read entire article »

Filed under: database, oracle

Recreating Database Link

January 18th, 2009 | 4 Comments

I was trying to recreate database links as part of database migration activity. This involved mixture of 8i,9i and 10g database. In case of 8i/9i it is very easy to find the old password which was used to create database link as passwords for database links are stored in Clear Text (decrypted format) in SYS.LINK$ .As a result we can easily re-create database links. Find below steps to perform the same SQL> set pages 1000 lines 80 SQL> col db_link for a20 SQL> col host for a20 SQL> col user_id for a20 SQL> SELECT NAME,HOST,USERID,PASSWORD FROM SYS.LINK$; NAME HOST USERID … Read entire article »

Filed under: database, oracle