How can we export and import schemas from oracle EBS 11i to oracle 11gR2 database.
Can you please let us know the objective of the exp/imp so that we may better assist you.
What is the target instance (standalone DB or EBS)? What schema are you trying to export? What is the version of the source Database?
Please answer the below questions:
What is the target instance (standalone DB or EBS)?
What is the version of the source Database?
You may either use Export/Import or Transportable tablespace for migrating the data. Please refer the following notes:
Export/import notes on Applications 11i Database 11g (Doc ID 557738.1)
Using Transportable Tablespaces for EBS Release 12.0 or 12.1 Using Database 11gR2 (Doc ID 1311487.1)
Exporting specific schemas is NOT supported and you will have to do a full export/import. If the target database/OS match the source ones then you can simply use Rapid Clone.
Q> Is possible to export and import following schemas from EBS to standalone DB?
It is NOT supported but you may give it a try (as long as the target database won't be used for EBS) -- I suspect it would work due to object dependencies.