How to create IFS DB structure without data?

  • 495 Views
  • Last Post 10 January 2018
  • Topic Is Solved
FlorianW posted this 10 January 2018

Hello,

I want to create a new IFS DB.

I'm trying to get an export from live system (structure only) and create new DB using this. DB creation works fine, but I get lot of errors when trying to create the middle tier.

What am I doing wrong? Can someone please help?

  • Liked by
  • chana05
  • Kartik
Order By: Standard | Newest | Votes
maxpdn posted this 10 January 2018

Usually meta data only copy will not work with IFS. Post the command used to export the DB.

  • Liked by
  • chana05
  • FlorianW
chana05 posted this 10 January 2018

Usually meta data only copy will not work with IFS. Post the command used to export the DB.

 

maxpdn is correct. You can use the initial oracle template given by IFS

  • Liked by
  • FlorianW
FlorianW posted this 10 January 2018

expdp ifsapp/xxxxx@xxxx DIRECTORY=IMP_DIR DUMPFILE=dumpfile.dmp FULL=y CONTENT=metadata_only

maxpdn posted this 10 January 2018

metadata_only copy will not work with IFS. IFS F1 settings such as system parameters, connect info etc, are stored in FND_ tables. These data will not be copied if you do metadata_only copy.

Either you have to get a full export or you can use IFS initial DB template as mentioned above. Usually this template can be found in build_home

FlorianW posted this 10 January 2018

Thank you for the information. I will try with template.

Close