Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by it2010
-
ORA-00604 followed by ORA-30036
I'm planning to try the following query: insert /*+APPEND*/ into local_table SELECT /*+ DRIVING_SITE(remote_view) */ LOWER (field_1) ,field_2,TO_CHAR(field_3,'YYYYMMDD'), my_local_function(field_4) FROM remote_view WHERE LOWER(field_5) in (select /*+ full(my_local_list)*/...- it2010
- Post #7
- Forum: Oracle: All versions
-
ORA-00604 followed by ORA-30036
Hi, It's not a row-by-row loop because the table "my_list" has 2-3 rows. I'm trying to identify the bottleneck of this system/procedure written by others (running in a production system every night), so I can't switch to SQL PLUS or change the output format for data fields. In the past they...- it2010
- Post #5
- Forum: Oracle: All versions
-
ORA-00604 followed by ORA-30036
Hi, this is the procedure's code: EXECUTE IMMEDIATE 'ALTER TABLE local_table NOLOGGING'; EXECUTE IMMEDIATE 'DROP INDEX aaaaaaaa'; EXECUTE IMMEDIATE 'DROP INDEX bbbbbbbb'; EXECUTE IMMEDIATE 'truncate table local_table'; for rec in (select distinct(lower(tipo)) tipo from my_list ) loop insert...- it2010
- Post #3
- Forum: Oracle: All versions
-
ORA-00604 followed by ORA-30036
Hello, I'm getting the following error: ORA-00604: error occurred at recursive SQL level 1 ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1' for the query (in a stored procedure of my local db): insert /*+APPEND*/ into local_table SELECT * from...- it2010
- Thread
- Replies: 6
- Forum: Oracle: All versions
