Re: Upgrade 11g to 12c - recyclebin

no rows selected

It's throwing the error from the statement "select count(*) from sys.recyclebin$;'

On Fri, Aug 28, 2015 at 11:53 AM, Lyall personal < lyallbarbour_at_sanfranmail.com> wrote:

> Also, u should be able to look into the 12c upgrade script to see how it
> gets that error
>
> Sent from my BlackBerry 10 smartphone.
> *From: *Peter Sharman
> *Sent: *Friday, August 28, 2015 1:47 PM
> *To: *sbecker6925_at_gmail.com
> *Reply To: *pete.sharman_at_oracle.com
> *Cc: *oracle-l
> *Subject: *RE: Upgrade 11g to 12c - recyclebin
>
> Oh well, always best to get the easy answer out first. J
>
>
>
> What do you get from a SELECT * FROM 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_at_oracle.com Twitter: _at_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_at_gmail.com]
> *Sent:* Saturday, August 29, 2015 3:33 AM
> *To:* Peter Sharman <pete.sharman_at_oracle.com>
> *Cc:* oracle-l <oracle-l_at_freelists.org>
> *Subject:* Re: Upgrade 11g to 12c - recyclebin
>
>
>
> 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_at_oracle.com>
> 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_at_oracle.com Twitter: _at_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_at_gmail.com]
> *Sent:* Saturday, August 29, 2015 3:12 AM
> *To:* oracle-l <oracle-l_at_freelists.org>
> *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
>
>

-- 
Sandy
GHX




--
http://www.freelists.org/webpage/oracle-l