r12.2

[Sri]

Hi Erman,

during prepare phase,will this keep a copy of all the tables in patch edition.when i connect to patch edition and check for the tables,i can see them


SQL> select count(*) from dba_tables;

  COUNT(*)
----------
     23967

SQL> select count(*) from fnd_concurrent_requests;

  COUNT(*)
----------
    872924

SQL> select count(*) from AP_INVOICES_ALL;

  COUNT(*)
----------
     98714


Thanks,

[ErmanArslansOracleBlog]

I tink you need to understand the EBR better.
EBR is Edition Based Redefinition.
You need to read about it, at least to understand what a database edition really is.
tables are non-editionable objects.
This means, you can't have different values in a table in different editions.
You can, however use the views which have different where clauses in each edition to see te table's data according to your edition.

Makes sense? Right?
so what you are seeing is normal.