Tech Rescue
  • Home
  • Acronyms
  • Cheat-Sheets
  • User Manuals

Oracle

How to execute .SQL files from console

Very easy, just log in into sqlplus and type as follows if you are in the same path as your file: SQL > @file_name.sql If you are not in the same path as your file, you should type as follows: SQL > @/path/to/file_name.sql What if I
Hector Perez Feb 24, 2014

How to create Oracle users in Oracle 11g XE

Here is how it’s done. 1. Log on as SYSTEM user C:Usersdelta1>sqlplus system SQL*Plus: Release 11.2.0.2.0 Production on Thu Feb 20 12:01:00 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 11g Express Edition
Hector Perez Feb 20, 2014

How to see available SIDs in Oracle

Once you have installed Oracle database and rebooted the system you can go to a command line window and type the following: C:Usersterminator>LSNRCTL SERVICES The response should look like this: LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 20-FEB-2014 10:23:51 Copyright
Hector Perez Feb 20, 2014
Tech Rescue © 2025. Powered by Ghost