Home » RDBMS Server » Server Utilities » space problem in imp utlity in oracle10g (Oracle 10.2.0.4 ,linux)
space problem in imp utlity in oracle10g [message #428476] Wed, 28 October 2009 08:26 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
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 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


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

Re: space problem in imp utlity in oracle10g [message #428481 is a reply to message #428476] Wed, 28 October 2009 08:34 Go to previous message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>only scripts in production database
use expdp to export only the procedures/functions..
or
just use remap_tablespace.

[Updated on: Wed, 28 October 2009 08:41]

Report message to a moderator

Previous Topic: ctl file loading
Next Topic: How to use subquery in query parameter of exp command
Goto Forum:
  


Current Time: Wed Sep 28 21:11:34 CDT 2016

Total time taken to generate the page: 0.11733 seconds