OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Purge Recyclebin (Oracle9i ,Windows)

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

Purge Recyclebin [message #278888]

Tue, 06 November 2007 02:52

sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai

Senior Member

Hi,
I export dump file to one instance.The export process completed sucessfully.After that i check in my instance, Some $bin$ objects are in my instance.

why these tables are created during the import?
What is the purpose of it?

Thanks,
Michael

Report message to a moderator

Re: Purge Recyclebin [message #278890 is a reply to message #278888]

Tue, 06 November 2007 02:59

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Not my field of expertise but I'd say: temporary objects?

MHE

Report message to a moderator

Re: Purge Recyclebin [message #278894 is a reply to message #278888]

Tue, 06 November 2007 03:36

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

Senior Member
Account Moderator

They were in the export file so they are created during import.
If you don't want them then purge your recycle bin before export.

Regards
Michel

Report message to a moderator

Re: Purge Recyclebin [message #278905 is a reply to message #278894]

Tue, 06 November 2007 04:42

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As I've understood it, @holdingbe noticed "recycled" objects after performing export. Something like this:

> EXP scott/tiger FILE=scott.dmp
> SQLPLUS scott/Tiger

SQL> SELECT * FROM tab;

     Now he noticed 'bin$' objects and (wrongly) guessed that
     export created them

Perhaps you'd want to check what recycle bin is and what to do with it.

Report message to a moderator

Re: Purge Recyclebin [message #278909 is a reply to message #278888]

Tue, 06 November 2007 04:47

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

Senior Member

Quote:

What is the purpose of it?

Nothing to do until you flashback to original one. You can simply ignore it.

Report message to a moderator

Previous Topic:	During Import Err
Next Topic:	impdb error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 23:30:43 CST 2024