[Filter: smut] John69's post body matched "*harshitha*", board "forumsmisc".

John69

[Filter: smut] John69's post body matched "*harshitha*", board "forumsmisc".

Post Subject: Re: Not able to sync the tables (main table and the subsidiary view)

Post Body:

Spoiler

---

harshitha.narayan@sony.com wrote: DMVNow

Hello All,

 

I have an issue where in there is table 1 with below structure:

List (category list)	Line item1	Line item 2	Difference
A1	12	5	7
A2	4	10	-6
B1	10	20	-10
B2	6	3	3
Total	32	38	-6

 

And there is a table 2, which is a Subsidiary view created based on a source module that is used bring the count/ values in table 1. The purpose of table 2 is to display all the information linked to each category , i.e is when I click on A1 I am able to drill down / get relevant information associated with Category A1, like wise for other category as well. But when I click on "TOTAL" row, the table 2 becomes blank with no drill down information where as I want to see the contrary.

 

Can someone please let me know what I am missing?

 

I can provide more information if required.

Use the RESYNC CATALOG command to perform a full resynchronization of metadata in a recovery catalog schema with metadata in a target database control file. You can also use the FROM CONTROLFILECOPY clause to resynchronize the current control file with the RMAN metadata in a control file copy.

Body text "harshitha" matched filter pattern "*harshitha*".

Post by User[id=88568,login=John69] has message uid 145162.

Link to post: Re: Not able to sync the tables (main table and the subsidiary view)