Run Oracle SQL script and exit from sqlplus.exe via command prompt
Another way is to use this command in the batch file: echo exit | sqlplus user/pass@connect @scriptname
sqlplus
How to display databases in Oracle 11g using SQL*Plus
You can think of a MySQL “database” as a schema/user in Oracle. If you have the privileges, you can query the DBA_USERS view to see the list of schemas:
SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
You’re missing service name: EDIT If you can connect to the database from other computer try running there: and
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
I had this issue and the fix was to make sure in tnsnames.ora the SERVICE_NAME is a valid service name in your database. To find out valid service names, you can use the following query in oracle: Once I updated tnsnames.ora to: then I ran: Success! The listener is basically telling you that whatever service_name … Read more