OraFAQ Forum: Server Utilities » space problem in imp utlity in oracle10g

Home » RDBMS Server » Server Utilities » space problem in imp utlity in oracle10g (Oracle 10.2.0.4 ,linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

space problem in imp utlity in oracle10g [message #428476]

Wed, 28 October 2009 08:26

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

Report message to a moderator

Re: space problem in imp utlity in oracle10g [message #428480 is a reply to message #428476]

Wed, 28 October 2009 08:34

babuknb
Messages: 1736
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

Report message to a moderator

Re: space problem in imp utlity in oracle10g [message #428481 is a reply to message #428476]

Wed, 28 October 2009 08:34

Mahesh Rajendran
Messages: 10707
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 03:51:16 CDT 2024