Database Administration (MOSC)

MOSC Banner

Sql Syntax Question - Dynamically create an externally identified account

edited Nov 13, 2014 10:00AM in Database Administration (MOSC) 2 commentsAnswered

Hello,

I am trying to write a script that will create an externally identified oracle account, but I need to pass a variable to the script to be incorporated into the account name as my unix accounts are named specific to my database name.  For example, my database name for the first db might be testadb and the second testbdb.  The unix account for the first db would be oratesta and the unix account for the second, oratestb.  In this scenario, the ops accounts needed would be ops$oratesta and ops$oratestb.  I am trying to script my create statement to accept a

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center