Re: Upgrade 11g to 12c - recyclebin

  • From: Sandra Becker <sbecker6925@xxxxxxxxx>
  • To: Peter Sharman <pete.sharman@xxxxxxxxxx>
  • Date: Fri, 28 Aug 2015 11:32:33 -0600

I was logged in as sys and did "purge recyclebin". I also did "purge
dba_recyclebin".

Sandy

On Fri, Aug 28, 2015 at 11:15 AM, Peter Sharman <pete.sharman@xxxxxxxxxx>
wrote:

Did you purge recyclebin (i.e. for the user) or purge dba_recyclebin?



Pete

[image: Oracle logo]

Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone: +61262924095 | | Fax: +61262925183 | | Mobile: *+61414443449
<%2B61414443449>*
Email: pete.sharman@xxxxxxxxxx Twitter: @SharmanPete LinkedIn:
au.linkedin.com/in/petesharman
Website: petewhodidnottweet.com
------------------------------

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook



"Oh no, it's not, it's much harder than that!"

Bruce Pihlamae, long term Oracle DBA
------------------------------



*From:* Sandra Becker [mailto:sbecker6925@xxxxxxxxx]
*Sent:* Saturday, August 29, 2015 3:12 AM
*To:* oracle-l <oracle-l@xxxxxxxxxxxxx>
*Subject:* Upgrade 11g to 12c - recyclebin



I can't get logged into MOS right now, so I'm posting my questions here. I
am preparing to upgrade an 11.2.0.4 database to 12.1.0.2. The preupgrd.sql
script returned the following error:


ERROR: --> RECYCLE_BIN not empty.
Your recycle bin contains 64 object(s).
It is REQUIRED that the recycle bin is empty prior to upgrading.
Immediately before performing the upgrade, execute the following
command:
EXECUTE dbms_preup.purge_recyclebin_fixup;

When I select a count from the recyclebin or dba_recyclebin, it returns
0. I went ahead and executed the statement. I then reran the preupgrd.sql
script. It showed the same error. I ran the preupgrade_fixups.sql script
and reran the preupgrd.sql script. It still shows the same error. The
executions to purge the recyclebin said they were successful.

What am I missing? Do I really need to rerun the preupgrd.sql script? Am
I looking in the wrong place for the count? This is the only error I had
for this database.


--

Sandy
GHX




--
Sandy
GHX

JPEG image

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2015