|
-
The first datafile may be fragmented, for which it is not able to create the initial extent.You can find out from the dba_free_space view, the no. of continous free space available.Since there is no continous free space of 400 MB it is giving this problem.
If you have another datafile in which the continous space is available, you can specify after the table creation the datafile the table has to use, using the :
alter table <tablename> allocate extent 'datafile' size;
Ramki
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|