|
-
Hi Sureshy,
I got the same error again during import. Now if I check dba_free_space, it shows no rows found.
select file_id,bytes from dba_free_space where tablespace_name = 'GLD'
No rows.
After than, I checked the biggest table. To my surprise, this table's next extent has got changed and it has become bigger. Its size also has got increased.
select bytes,extents,initial_extent,next_extent,pct_increase from dba_segments where segment_name = 'GL_JE_LINES'
493625344 118 16384 4218880 0
Originally, it was as below.
450150400 1193 16384 524288 0
What has caused this change in spite of not giving COMPRESS=Y while export?
Can you suggest me what to do as I need to import this schema back to start my database.
Thanks,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
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
|