In addition to the database user name and password, a connect string includes a host name or host IP address, an optional TCP port number, and an optional database service name. To connect remotely, you must supply not just a user name and password, but a complete Oracle Net conne ct string.
#ORACLE SQL COMMAND LINE CLIENT SOFTWARE#
Oracle client software for Oracle Database Enterprise Edition or Standard Edition (all supported releases of Oracle Database 8, 8 i, 9 i, and 10 g)Īll Oracle client software includes Oracle Net, which is the Oracle network software that enables client applications on one computer to connect to databases on another computer over a network.
#ORACLE SQL COMMAND LINE CLIENT INSTALL#
You can install Oracle Database XE Client separately on remote computers. When you install Oracle Database XE, Oracle Database XE Client is also installed on the same computer. Oracle Database Express Edition Client (Oracle Database XE Client) Oracle Database XE accepts connections from all of the following types of Oracle clien t software: It is through Oracle client software that Oracle command-line utilities (and your applications) connect to the database. The remote computer must have Oracle client software installed. The following topics are covered:Ĭonnecting Remotely with SQL Command LineĮnvironment Variables Reference for LinuxĬonnectin g remotely means running SQL Command Line (or any other Oracle command-line utility) on a computer other than the Oracle Database XE host computer, and then initiating a database connection from SQL Command Line (or other utility) over the network. "Importing, Exporting, Loading, and Unloading Data"īulk-load data into the database from external files.Īlthough connection concepts apply to all utilities, this section focuses on SQL Command Line (SQL*Plus), because you use it for database administration. "Using SQL Command Line" in Oracle Database Express Edition 2 Day Developer GuideĮxport and import data from one Oracle database to another.
Table 3-1 Oracle Database XE Command-Line Utilities UtilityĪdminister the database create, alter and drop database objects run SQL queries and run SQL and PL/SQL scripts.
0 kommentar(er)
