| space problem in imp utlity in oracle10g [message #428476] |
Wed, 28 October 2009 08:26  |
|
Hi,
I have taken dump for specifc schema with 0 rows i.e only scripts in production database using exp utlity.In production database, the tablespace inital size is 1GB with max size unlimited.I have imported the exported dump file into local machine.During the loading, the tablespace size is overflow. we are getting unable to extents tablespace error. My local machine tablespace inital size is 100MB with max size unlimited.but in os level, some space is present.
i want to load these dump into local machine without production tablespace size.
Please help me..
Thanks,
Michael
|
|
|
| Re: space problem in imp utlity in oracle10g [message #428480 is a reply to message #428476] |
Wed, 28 October 2009 08:34  |
|
Post your export command
Post your import command.
Post your import error log details.
Post Newly created tablespace free space & used space details.
>>In production database, the tablespace inital size is 1GB with max size unlimited
Check current size of your tablespace using DBA_DATA_FILES
- Babu
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
