Home » RDBMS Server » Server Utilities » How to craete dump file of tablespace  () 1 Vote
How to craete dump file of tablespace [message #263572] Thu, 30 August 2007 07:29 Go to next message
manasbis
Messages: 8
Registered: August 2007
Junior Member
Can anybody tell me, how to export all data in a tablespace in Oracle 8.1.7

[Updated on: Thu, 30 August 2007 08:04]

Report message to a moderator

Re: How to craete dump file of tablespace [message #263579 is a reply to message #263572] Thu, 30 August 2007 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle version?

Regards
Michel
Re: How to craete dump file of tablespace [message #263586 is a reply to message #263579] Thu, 30 August 2007 08:05 Go to previous messageGo to next message
manasbis
Messages: 8
Registered: August 2007
Junior Member
Oracle 8.1.7
Re: How to craete dump file of tablespace [message #263588 is a reply to message #263586] Thu, 30 August 2007 08:11 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
exp help=y should give you what you need.

Use the TABLESPACES keyword.
Re: How to craete dump file of tablespace [message #263595 is a reply to message #263588] Thu, 30 August 2007 08:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TABLESPACES keyword is only for transportable tablespaces.

@manasbis
Do you want to export data or transport tablespace from one db ot another one?

Regards
Michel
Re: How to craete dump file of tablespace [message #263599 is a reply to message #263595] Thu, 30 August 2007 08:34 Go to previous messageGo to next message
manasbis
Messages: 8
Registered: August 2007
Junior Member
No, actually one of my datafiles got corrupted and by mistake archive log lost. So I decided to export all the data in the tablespace and drop the tablespace and recreate the same again import back the data. That's why I need to export the tablespace.
Re: How to craete dump file of tablespace [message #263604 is a reply to message #263599] Thu, 30 August 2007 08:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So find all all tables in your tablespace (query dba_segments) and then use TABLES keyword on exp command.

Regards
Michel
Re: How to craete dump file of tablespace [message #263673 is a reply to message #263595] Thu, 30 August 2007 13:06 Go to previous message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
Michel Cadot wrote on Thu, 30 August 2007 09:25
TABLESPACES keyword is only for transportable tablespaces.



Whoops, thanks for pointing that out.
Previous Topic: Using 9i Export whole db while excluding couple of tables
Next Topic: imp utility
Goto Forum:
  


Current Time: Fri Dec 09 00:20:22 CST 2016

Total time taken to generate the page: 0.20933 seconds