database script

[Roshan]

Hello Erman,

can you please help me with a database script?
ACTT_OracleDB_11g_UNIX_4.sh

which user should I specify? sys user and sys password?
what database string should I input?

Thanks,
Roshan

[ErmanArslansOracleBlog]

It runs the following sql:

sqlplus $APPUSER/$APPPWD@$STRN @Oracle_DB_Extractor_11g_Above_4.0.sql

So, check the sql.. It wants a database user which is cabapbe of doing what is instructed in the above sql. So check the sql and see the details. SYS can do anything ,but again check the above sql and see.

[Roshan]

Hi,

the sql script contains sys user.
ACTT_OracleDB_11g_UNIX_4.sh

[ErmanArslansOracleBlog]

Check this script: @Oracle_DB_Extractor_11g_Above_4.0.sql

It seems all the db work is done in this script.
So, supply a user to the script. The user that you will supply, should have all the necessary grants to do all the things written in Oracle_DB_Extractor_11g_Above_4.0.sql.