i have faced this error when i am insert data by using for loop for 200 rows .
ORA-12519: TNS:no appropriate service handler found tips
i select the this query but how can i solve this problem.
select * from v$resource_limit where resource_name = 'processes';
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE
------------- ------------------- --------------- -----------
processes 148 150 150
i mean which value should i update.
regards
Ayham
Edited by: Ayham on Nov 28, 2012 9:57 PM