Problem:
8i SQL*Loader failed with error message SQL*Loader-704:Internal error:ulnail: bad row out of bounds [21]. Target database is 10g.
Troubleshooting:
Tried option DIRECT=TURE but failed as 10g database doesn't support such option from 8i client.
Solution:
Add parameter bindsize=500000 and succeed.
Popular Posts
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
I have one PT env using storage sync for database sync. Thought need to re-register DB after DB refresh, so unregister and register again....
-
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
-
backup piece The physical file format used to store RMAN backup sets backup set A backup of one or more datafiles, control files, SPFILEs...
-
Oracle collects Active Session History (ASH) statistics (mostly wait statistics for different events) for all active sessions every second f...
-
1. The application error message orarac2poc:ORCL2:/u01/app/oracle/oms12c/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs&g... -
after rounds of recovery testing, I believer there are tons of obsolete files in FRA. There are some stubborn datafile copy can't be de...
-
1. The dictionary view of dba_tab_col_statistics https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_2089.htm#REFRN20275 No...
-
able to create todo item but not able to view todo item due to below error in APEX 5.1.4 ORA-20104: create_collection_from_queryb2 Error:... -
This installation extended to my home hour, since both Postgresql and Zabbix are new to me. Followed few articles without much difficulty....