OraFAQ Forum: Server Utilities » Using 9i Export whole db while excluding couple of tables

Home » RDBMS Server » Server Utilities » Using 9i Export whole db while excluding couple of tables

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

Using 9i Export whole db while excluding couple of tables [message #263262]

Wed, 29 August 2007 09:25

luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad

Junior Member

Using the Oracle 9i export utility is it possible to exclude couple of tables while taking a whole database backup ..

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263264 is a reply to message #263262]

Wed, 29 August 2007 09:27

luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad

Junior Member

luckyally wrote on Wed, 29 August 2007 19:55

Using the Oracle 9i export utility is it possible to exclude couple of tables while taking a whole database backup ..

possible to exclude couple of tables while taking a whole database export ..

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263265 is a reply to message #263264]

Wed, 29 August 2007 09:35

luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad

Junior Member

Also let me know how to do it ..

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263289 is a reply to message #263262]

Wed, 29 August 2007 10:54

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is a Metalink note on the subject.

Regards
Michel

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263377 is a reply to message #263262]

Wed, 29 August 2007 22:15

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You can use tables=1,2,3,...

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263443 is a reply to message #263377]

Thu, 30 August 2007 01:36

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Arju wrote on Thu, 30 August 2007 05:15

You can use tables=1,2,3,...

This is INCLUDE tables and not EXCLUDE tables.

Regards
Michel

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263453 is a reply to message #263262]

Thu, 30 August 2007 02:12

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Yes , Michel as he cannot use datapump, he has no way . By the way I got metalink access. Cool

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263468 is a reply to message #263453]

Thu, 30 August 2007 02:27

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

he has no way

There is one, explained in a Metalink note.

Regards
Michel

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263473 is a reply to message #263262]

Thu, 30 August 2007 02:29

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Can you give me the reference.I want to see how.

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263480 is a reply to message #263473]

Thu, 30 August 2007 02:56

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't have its number (otherwise I posted it) but I read it several years and know the note exists.
Now I think you can do a search as well as I can myself.
If you don't find it, tell me I will try.

Regards
Michel

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263492 is a reply to message #263480]

Thu, 30 August 2007 03:25

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Michel / Arju,
Are you searching for Note 162914.1?

By
Vamsi

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263497 is a reply to message #263262]

Thu, 30 August 2007 03:35

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Yes, Thanks Kasina.

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263498 is a reply to message #263492]

Thu, 30 August 2007 03:36

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, this is this one.

Thanks
Michel

Report message to a moderator

Re: Using 9i Export whole db while excluding couple of tables [message #263502 is a reply to message #263492]

Thu, 30 August 2007 03:46

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Tanel Poder once posted an unsupported way to do it there.

Regards
Michel

[Updated on: Thu, 30 August 2007 03:47]

Report message to a moderator

Previous Topic:	DB Export problem
Next Topic:	How to craete dump file of tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 10:16:07 CST 2024