Home » RDBMS Server » Server Utilities » Purge Recyclebin (Oracle9i ,Windows)
icon2.gif  Purge Recyclebin [message #278888] Tue, 06 November 2007 02:52 Go to next message
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
Re: Purge Recyclebin [message #278890 is a reply to message #278888] Tue, 06 November 2007 02:59 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Not my field of expertise but I'd say: temporary objects?

MHE
Re: Purge Recyclebin [message #278894 is a reply to message #278888] Tue, 06 November 2007 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Purge Recyclebin [message #278905 is a reply to message #278894] Tue, 06 November 2007 04:42 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: Purge Recyclebin [message #278909 is a reply to message #278888] Tue, 06 November 2007 04:47 Go to previous message
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.
Previous Topic: During Import Err
Next Topic: SQLLDR Error : Field in data file exceeds maximum length
Goto Forum:
  


Current Time: Sun Dec 04 00:22:22 CST 2016

Total time taken to generate the page: 0.09690 seconds