Create local repository in Oracle

Pre-requisites

Need the grant’s

Create session,

Create view

Create sequence to

Create Procedure

There are two ways to create a repository, through the operating system with the following command:

./repoman –Uuser –Ppassword –Stnsnames –Noracle -c -o

Where “repoman” is the application, “-U” option is the user, the “-P” option is the password, the “S” option is the connection string in case the above is the tns, “- N c “type database, the” “is to create, and the” -o “is to force a new creation if there is already a user.

Below is an example of creating, through the operating system.

Or through the Data Services Repository Mananger application installed on the backend.