| ashu |
Posted: Jan 30, 2008 08:05:13 AM |
Total Post: 1
Joined: Jan, 2008
|
Hi all,
I am trying to create index on a table having more than 5 milian rows..
but I m getting ORA-000603 Oracle session termineted by fatal error.
How can i resolve this problem...
Thanks
|
|
|
Mohammed Taj |
| Posted: Jan 31, 2008 09:55:59 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
also post another error message which come ora-00603 error.
check alert log file.
|
|
|
|
|
positive |
| Posted: Jun 27, 2008 06:07:41 PM | |
|
Total Post: 361
Joined: Jun, 2008
|
The table is a large table and hence profile limits ,resource_limit=true vslue set in initSID.ora file could be the reason.
|
|
|
|
|
moni |
| Posted: Jul 04, 2008 06:06:12 AM | |
|
Total Post: 4
Joined: Jul, 2008
|
Most of the times we have error while creating the indexes because we didn't have enough space in temporary tablespace. Please check whether your temporary tablespace is free or not. As you have mentioned that your table is having millions of rows. Hope this will help you.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |