query regarding clone
Hello Team,
We have a legacy Oracle database that originally hosted an Oracle E-Business Suite R12 application. At a later stage, the same database was also used as the database for an OBIEE installation.
As a result, the database currently contains the OBIEE created tablespaces and default schemas (for example: MDS, BIPLATFORM, OPSS, STB, IAU, UMS, WLS, etc.). The OBIEE application server is hosted separately and is not part of this database clone activity.
We need to refresh/clone this non-production database from the current PROD EBS database. However, the PROD database does not contain the OBIEE tablespaces or schemas.