Collections:
Connect SQL*Plus Session to Oracle Server in Oracle
How To Connect a SQL*Plus Session to an Oracle Server in Oracle?
✍: FYIcenter.com
In order to connect a SQL*Plus session to an Oracle server, you need to:
1. Obtain the connection information from the Oracle server DBA.
2. Define a new "connect identifier" called "FYI_XE" in your tnsnames.org file with the given connection information.
3. Run the CONNECT command in SQL*Plus as shown in the tutorial exercise below:
>cd c:\oraclexe\app\oracle\product\10.2.0\server\ >.\bin\sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Tue ... Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> CONNECT fyi/retneciyf@FYI_XE; Connected. SQL> SELECT SYSDATE FROM DUAL; SYSDATE --------- 05-MAR-06
⇒ Error: Could not Resolve the Connect Identifier in Oracle
⇐ What Is a Connect Identifier in Oracle
2020-08-13, 2550🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...