Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create an apex collection to store and loop through the values

NewApexCoderMay 29 2013 — edited May 30 2013
I couldn't find any simple example to do this
Apex 4.2

I need to create an apex collection. I have a query that returns multiple roles for a user. I need to check to see if one of my item values is within the collection but am not sure how to do so. So far I have:

begin
APEX_COLLECTION.CREATE_COLLECTION (
p_collection_name => 'ALL_ROLES');

select count(granted_role) into count from dba_role_privs where upper(grantee) = upper(:APP_USER);

end;

How would I store the query results in the collection?
This post has been answered by Anton Scheffer on May 29 2013
Jump to Answer

Comments

KanchDev
Hi Jumbo,

You can consider an incremental rman backup from production database and recover DR database.

This method is available from 10g. otherwise you need to recreate the Standby database.


Cheers,
Kanchana.
1 person found this helpful
CKPT
If the DR is not functioning from last 6 months, According to database size you can rebuild standby database.

if the data difference is not so huge, You can perform incremental roll forward.

For 10g, refer this below link

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#CIHIAADC
1 person found this helpful
Shivananda Rao
As said, you can recreate the standby database if the size of the production database is quite less. If not, then make use of the incremental or rollforwarding method.

Refer this MOS ID *Steps to perform for Rolling forward a standby database using RMAN incremental backup when primary and standby are in ASM filesystem [ID 836986.1]*
SITI
Hi SRP,

DB status:

1.*No ASM storage.*

2.*oracle 9i.*

3.*Archive logs deleted on both Primary and Standby.*

my question:

1.without recreate standby.*is their any method to recover the standby database?*

Regards,
Jumbo.
Shivananda Rao
Since you have lost the archives on the primary database, it is not possible for you to recover your standby database.

The only option is to recreate it fully (if the size of the primary database is small) or to go with the roll forwarding method.
1 person found this helpful
Ganadeva
Hi,

Try this for 9i

Rolling a Standby Forward using an RMAN Incremental Backup in 9i [ID 290817.1]

Please let us know if this works...

Regards,
Ganadeva
1 person found this helpful
SITI
thank you for all.
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 27 2013
Added on May 29 2013
#apex, #apex-discussions, #pl, #sql
10 comments
2,728 views