skip to main
|
skip to sidebar
Scribbling Notes
Friday, April 27, 2012
SP2-0027: Input is too long (> 2499 characters) - line ignored
RUNNING a very long insert with xml data to put into a clob column gave this issue on sqlplus.
sqldeveloper helped in this case...
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
Popular Posts
impdp
expdp system/managerpopv dumpfile=reporter.dmp directory=tmp schemas=reporter impdp system\acomp directory=tmp dumpfile=opvdb.dmp remap_sch...
ORA-19951: cannot modify control file until DBNEWID is completed
nid system/manager dbname=mtrx22 while running nid on a cloned database I forgot to check the tempfile which resulted into following error ...
rman to restore archivelog from backupset and synch a standby db
To list the backup sets of the archive logs. Where or which sets we have the archive logs. RMAN> list backup of archivelog logseq 5594; B...
oracle 10g database characterset change
ORACLE DB version 10.2.0.3 step 1- run csminst.sql it will create a user to hold csscan result. which the csalter will use to convert step ...
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
After moving the backup directory to a NFS for one 10gR2 db I started getting this error. RMAN-03009: failure of backup command on ORA_DISK_...
ORA-17628: Oracle error 19505 returned by remote Oracle server
precreate the contolfile directory in asm diskgroup then retry the duplicate from active database
copy schema using dbms_datapump
declare hand number; js varchar2(9); -- COMPLETED or STOPPED begin -- and owner in ('BACKUP','GATEKEEPER','REFDATA...
goldengate vip getting connection refused
goldengate bidirectional replication on site A,site B,site C the goldengate vip is configured on site A . but this morning when i came ...
ORA-10980 in trace file while creating materialized view?"
I was getting ORA-10980 in trace files. After granting all the permission still was not able to create the materialized view. but somehow p...
recovery using online redo logs for a norarchivelog database
after the platform services did the san migration somehow one of the datafile became corrupted and while i try to open the database it com...
Blog Archive
►
2013
(24)
►
November
(1)
►
August
(1)
►
July
(2)
►
June
(4)
►
May
(3)
►
April
(2)
►
March
(4)
►
February
(3)
►
January
(4)
▼
2012
(1)
▼
April
(1)
SP2-0027: Input is too long (> 2499 characters) - ...
►
2011
(15)
►
September
(1)
►
May
(3)
►
March
(5)
►
February
(3)
►
January
(3)
►
2010
(14)
►
December
(9)
►
May
(1)
►
April
(2)
►
March
(1)
►
January
(1)
►
2009
(10)
►
December
(3)
►
June
(1)
►
April
(1)
►
March
(4)
►
February
(1)
►
2008
(14)
►
December
(1)
►
September
(1)
►
July
(1)
►
June
(1)
►
April
(2)
►
March
(1)
►
January
(7)
►
2007
(53)
►
December
(15)
►
November
(33)
►
October
(5)
About Me
Prasad N
View my complete profile
