OraFAQ Forum: Server Utilities » How to craete dump file of tablespace

Home » RDBMS Server » Server Utilities » How to craete dump file of tablespace (

) 1 Vote

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

How to craete dump file of tablespace [message #263572]

Thu, 30 August 2007 07:29

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

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle version?

Regards
Michel

Report message to a moderator

Re: How to craete dump file of tablespace [message #263586 is a reply to message #263579]

Thu, 30 August 2007 08:05

manasbis
Messages: 8
Registered: August 2007

Junior Member

Oracle 8.1.7

Report message to a moderator

Re: How to craete dump file of tablespace [message #263588 is a reply to message #263586]

Thu, 30 August 2007 08:11

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

exp help=y should give you what you need.

Use the TABLESPACES keyword.

Report message to a moderator

Re: How to craete dump file of tablespace [message #263595 is a reply to message #263588]

Thu, 30 August 2007 08:25

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: How to craete dump file of tablespace [message #263599 is a reply to message #263595]

Thu, 30 August 2007 08:34

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.

Report message to a moderator

Re: How to craete dump file of tablespace [message #263604 is a reply to message #263599]

Thu, 30 August 2007 08:44

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: How to craete dump file of tablespace [message #263673 is a reply to message #263595]

Thu, 30 August 2007 13:06

joy_division
Messages: 4963
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.

Report message to a moderator

Previous Topic:	Using 9i Export whole db while excluding couple of tables
Next Topic:	imp utility

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 22:43:37 CDT 2024