how to use sqlplus

  In the R & D center, a database running oracle and sqlserver on Windows is an old machine with three hard disks attached, however, I recently received a request from my colleague saying that the disk where the oracle database data file is located

You can use sqlplus to connect to an Oracle database and then use the database interactively. Another non-interactive method is to directly execute SQL commands through shell. You can use sqlplus to connect to an Oracle database and then use the

The following steps teach you how to manually delete an Oracle11g database in a Linux environment. I installed the Oralce11G database on CentOS6. Use SQLPlus or others The following steps teach you how to manually delete an Oracle 11g Database in a

Common ORACLE commands spoolhost none -- use sqlplus to connect to the database -- standard usage sqlplususernamepassword @ hostname: portSERVICENAME -- Sample sqlpluspaymentpassword@192.168.117.1pay -- hostname: portSERVICENAME can be configured as

In Red Hat LinuxVirtual MachineInstall OnOracleThe prompt is as follows:ORA-12514Error. How can this problem be solved? This article introduces the solution to this error. Now let's take a look at this process. Solution: [Oracle @

Three default accounts: For Oracle 9:Sys change_on_install Network Administrator [as sysdba]System manage local administratorScott tiger is locked by default and can be used only after being unlocked. For Oracle 10: Sys and system do not have a

The concise installation and operation instructions of oracle8.05 oralce's support for Linux gives us a good opportunity to free her, but many netizens are not professionals (just like me ), I will write some of my operation programs, hoping to help

Share the process of connecting to the oracle database using php in windwos. To connect to oracle using php, the basic conditions are 1. you need to install php, 2. install oracle, 3. configure tnsname. ora. The local command line can use sqlplus to

Sqlplus Problems in Interactive interface Two non-interactive ways to use Sqlplus 1 via external command file 2 via standard input Use the pipe to do the processing Places to watch A simple script 1

Sqlplus Problems in Interactive interface Two non-interactive ways to use Sqlplus 1 via external command file 2 via standard input Using pipelines for follow-up treatment Places to be aware of A simple script

Sqlplus Problems in Interactive interface Two non-interactive ways to use Sqlplus 1 via external command file 2 via standard input Using pipelines for follow-up treatment Places to be aware of A simple script

1. after you forget your username and password, the system prompts invalid username and password after you try several Oracle Default usernames and passwords (The table contains the default username and password,UsernamePasswordDescriptionSee

Rac creates a data file in a non-shared location. oracle 11g 11.2.0.1linux server 64-bit 5.4 node1: Creates a data file '/tmp/rman. dbf' is not stored in the shared disk. Then, a table casd is created and data is added. In this case, the following

I believe that many beginners after installing oracle software, login to the database will encounter the following error: Ora-12514: TNS: listeners are currently unable to identify the request in the Link descriptor service. Check that the listener

Sysdba cannot log on remotely. What should we do (reprinted) and sysdba log on remotely?Sysdba cannot log on remotely, which is also a common problem. How can we solve this problem? When we use sysdba to log on, it is necessary to manage our

Query the character set of the current databaseBYS @ bys1> select userenv ('language ') from dual;USERENV ('language ')----------------------------------------------------AMERICAN_AMERICA.AL32UTF8BYS @ bys1> select * from

Detailed steps for installing oracle xe in centos, centos 1. Download the installation package Go to the official website and find the corresponding version. 2. Upload to ECs Here, I use WinSCP. the upload speed is based on the network speed. You

The path to installing and detaching Oracle databases: The Path to oracle databases ========================================================== ============================================== ====================================== 1. If there are two

I think in this age, few developers will use sqlplus, which is a primitive tool. However, many DBAs may like it, but I really don't like it, toad is easy to use! Unfortunately, sqlplus is not often used. Here, we despise the Security Department in

1. Determine the server version Choose your Oracle Server version first to download the appropriate client. Look at the following sql: SELECT * from V$version; If you can't connect to Oracle remotely, you can only log on to the server. 2. Download