CODEWITHSUNDEEP
oracle-databasesqlplus
unknownDev
unknownDev

Reputation: 31

Oracle command, meaning of the part after sysdba

Can someone please tell me what does it mean @test.sql in the Oracle command:

sqlplus sys/pw@somedb as sysdba @test.sql

Upvotes: 1

Views: 227

Answers (2)

Shiwangini
Shiwangini

Reputation: 836

sqlplus sys/pw@somedb as sysdba can be also written as sqlplus sys/pw@sid as sysdba , it mean is you use passwordfile authorization and @test.sql is the script ,you want to get executed.

Upvotes: 0

Mureinik
Mureinik

Reputation: 312404

test.sql is a script to be executed.

This entire line logs into somedb with user sys using password pw as sysdba and runs the test.sql script.

Upvotes: 3

Related Questions