Home » RDBMS Server » Server Utilities » Data Pump Inquiry (Oracle 10g)
Data Pump Inquiry [message #476689] Fri, 24 September 2010 10:10 Go to next message
ggibbs71
Messages: 2
Registered: September 2010
Junior Member
I am considering all of the capabilities and benefits of using Data Pump for exporting and importing extremely large data files. Would like to know if importing to tape is possible? If so, would the data be accessible if needed later?

Thanks
Re: Data Pump Inquiry [message #476692 is a reply to message #476689] Fri, 24 September 2010 10:18 Go to previous messageGo to next message
BlackSwan
Messages: 21936
Registered: January 2009
Senior Member
expdp & impdp operate against standard OS disk files.
All tape operations are between you & tape MML.
Re: Data Pump Inquiry [message #476694 is a reply to message #476692] Fri, 24 September 2010 10:35 Go to previous messageGo to next message
ggibbs71
Messages: 2
Registered: September 2010
Junior Member
So, does your answer mean that I will be able to import to tape?

What specifically is MML?

Re: Data Pump Inquiry [message #476696 is a reply to message #476694] Fri, 24 September 2010 10:50 Go to previous messageGo to next message
BlackSwan
Messages: 21936
Registered: January 2009
Senior Member
Media Management Library (MML)
Re: Data Pump Inquiry [message #476708 is a reply to message #476696] Fri, 24 September 2010 14:15 Go to previous message
Littlefoot
Messages: 18818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Documentation says:
Quote:
Sequential media, such as tapes and pipes, are not supported.


Even if you could do that, what an awful performance it would be! Imagine your "extremely large" amount of data accessed while on tape. Horr ... ible!
Previous Topic: synonyms compilation error
Next Topic: ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload
Goto Forum:
  


Current Time: Wed Apr 16 00:25:58 CDT 2014

Total time taken to generate the page: 0.25125 seconds