Home » RDBMS Server » Enterprise Manager » problem while importing from a without data dump
problem while importing from a without data dump [message #267319] Thu, 13 September 2007 00:54 Go to next message
sudhir_sahu
Messages: 10
Registered: September 2007
Junior Member
While importing a dump from without data export it takes as much space as there is data in the imported database.so please tell me that how should I import.I need only structure and I donot have that much of disk space
Thanks in advance.

[Updated on: Thu, 13 September 2007 06:35]

Report message to a moderator

Re: problem while importing from a without data dump [message #267329 is a reply to message #267319] Thu, 13 September 2007 01:07 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>While importing a dump from without data export it takes as much space as there is data in the imported database.
OK, I agree.
Tablespace take disk space; regardless of whether data exists or not.
You got what was expected.
Re: problem while importing from a without data dump [message #267342 is a reply to message #267319] Thu, 13 September 2007 01:30 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Laughing
Re: problem while importing from a without data dump [message #267348 is a reply to message #267329] Thu, 13 September 2007 01:39 Go to previous messageGo to next message
sudhir_sahu
Messages: 10
Registered: September 2007
Junior Member
But I donot have this much of space.
Then what can I do while importing so that it do not take this much of space
Re: problem while importing from a without data dump [message #267355 is a reply to message #267319] Thu, 13 September 2007 01:47 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

In the first thread I think you was unable to express your requirement. After getting your 2nd thread, I got an idea you are in problem with disk space. In that case you can use transport_tablespaces feature.
Re: problem while importing from a without data dump [message #267462 is a reply to message #267355] Thu, 13 September 2007 06:32 Go to previous messageGo to next message
sudhir_sahu
Messages: 10
Registered: September 2007
Junior Member
could you please tell me in detail.
Re: problem while importing from a without data dump [message #267464 is a reply to message #267319] Thu, 13 September 2007 06:41 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#i1007169
Previous Topic: cannot login into Oracle 10g OEM
Next Topic: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)
Goto Forum:
  


Current Time: Tue Dec 06 06:39:54 CST 2016

Total time taken to generate the page: 0.09058 seconds