Home » SQL & PL/SQL » SQL & PL/SQL » intial extent creation problem in jdeveloper
intial extent creation problem in jdeveloper [message #270623] Thu, 27 September 2007 12:16 Go to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
Hi
i was creating a table using oracle's jdeveloper tool and at the end,i got an error message "unable to create initial extend for the segment in the tablespace".Please help me if know how to solve this.
Many thanks
Ryju

Thank you very much

[Updated on: Thu, 27 September 2007 12:55] by Moderator

Report message to a moderator

Re: intial extent creation problem in jdeveloper [message #270624 is a reply to message #270623] Thu, 27 September 2007 12:17 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
1) use a different tablespace that has enough free space.
2) add another datafile to this tablespace
Re: intial extent creation problem in jdeveloper [message #270643 is a reply to message #270623] Thu, 27 September 2007 13:06 Go to previous messageGo to next message
RyjuRaju
Messages: 48
Registered: September 2007
Member
Thank you very much
Re: intial extent creation problem in jdeveloper [message #271155 is a reply to message #270623] Sun, 30 September 2007 03:42 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

3)Resize datafile under the tablespace to bigger one+grant quota on the tablespace.
4)Specify maxsize unlimited of the tablespace+autoextend on.
Previous Topic: help with the error PLS-00306:
Next Topic: grant required to create the table through API
Goto Forum:
  


Current Time: Sat Dec 10 18:24:34 CST 2016

Total time taken to generate the page: 0.14473 seconds