Skip to Main Content
Forums

Java Development Tools

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Requirement for a specific type of tree from HR schema.

Sunanda DasAug 18 2015 — edited Aug 18 2015

Hi,

I am using JDev 11.1.1.7.0.

I have a requirement to design a tree which would look like: ADF_Tree_Requirements.png

Is it possible with Single VO , or shall I use both the VO's of Employees and Departments tables.

I have already tried to replicate the same by creating a separate VO from existing entities, but my output is somewhat not as per my requirements.

Manager-Departments Tree.png

Here in my tree, I have the Root Node (EmployeeId, Employee Name, Manager Id, Department Id) which in itself is all the managers in my table.

The First Child node(ManagerIdModifiedManagersofEmployees) is employees under the Managers in similar format.

Second Child Node is Department of the Root Node Employee.

My requirement is to get the Department of the Root Node as a Child_Node_1, followed by Department of the Child_Node Employee(If any) as described in my first image of this post.

For a clear understanding I will try to explain my requirement using the last Root Node in my tree. Last Root Node is of Lex (Employee Id - 102, Employee Name - Lex, Manager Id - 100, Department - 90). Lex himself works in department as"Executive", and in turn is Manager for Alexander (Employee Id - 103, Employee Name - Alexander, Manager Id - 102, Department - 60). Alexander works for "IT" department.

My requirement is to get a tree which displays Lex as root node, followed by his department "Executive" as child_node_1, followed by department "IT" as child_node_2 under "Executive".

Final_Tree.png

Comments

Robert Geier
I don't know of any way to automatically switch to a second destination when the first is full.

You could :-

1. backup and delete files
2. move or zip files
3. increase the size of the destination
4. change the log_archive_dest using "alter system"
Azar
Backup archive log to tape or somewhere


rman>backup archivelog delete input
589266
Robert Geier wrote:
I don't know of any way to automatically switch to a second destination when the first is full.

You could :-

1. backup and delete files
2. move or zip files
3. increase the size of the destination
4. change the log_archive_dest using "alter system"
----

I have been doing it.....
but I want to make it automatic....
Robert Geier
So you just need a scheduled job to run rman job "backup archivelog all delete input". You can run from cron, or database scheduler, or OEM agent.
Hi,

Archive logs are very important when it comes to recovery. So backing up the archive logs is very important.

Backup your archive logs daily and maintain the archive logs for three days(this should be decided the size of your destination and how many archive logs generate for a day) on the disk.

The below command will backup the archivelogs and delete the archive logs generated before three days
BACKUP ARCHIVELOG ALL;
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;
Regards,
Vijayaraghavan K
EdStevens
Vijayaraghavan Krishnan wrote:
Hi,

Archive logs are very important when it comes to recovery. So backing up the archive logs is very important.

Backup your archive logs daily and maintain the archive logs for three days(this should be decided the size of your destination and how many archive logs generate for a day) on the disk.

The below command will backup the archivelogs and delete the archive logs generated before three days
BACKUP ARCHIVELOG ALL;
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;
Regards,
Vijayaraghavan K
You're on the right track, but how do you figure the above has any knowledge of "3 days old"?
Robert Geier
For archivelogs I prefer something like :-

delete noprompt force archivelog all completed before "sysdate-3" backed up 2 times to device type 'SBT_TAPE';
Hi Stevens,

Sorry my command was wrong for the above scenario, it will delete all expired backup.

I need to use the below command.
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-3' ALL DELETE ALL INPUT;
Regards,
Vijayaraghavan K
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 15 2015
Added on Aug 18 2015
#application-development-in-java, #jdeveloper, #jdeveloper-and-adf, #tree
0 comments
180 views