how to use sqlplus

Question 1: How can I determine whether my data is stored in Oracle Spatial? 1. SQL> DESC polygon_st2. Is the name empty? Type3 .-----------------------------------------------------------------------------4. objectid not nullnumber (38)5. Name

How to diagnose the error time returned by sysdate in rac, racsysdateRecently, some rac environments have been used to access sysdate and return the error time. This problem often occurs when the database link is created through Listener, and, in

1. Upgrade the SLES9 kernel and install the asm package. Ensure that the version is consistent.2./etc/init. d/oracleasm configure the asm driver user as the oracle dba group and start automatically.3. Prepare the raw disk to use fdisk for

Today I encountered a strange problem: Using sqlplus on the client allows normal users to log on, but neither system nor sys users can log on, prompting ORA-12154: TNS: unable to resolve the specified connection identifier [@ More @] SQL> conn

How to diagnose the error time returned by sysdate in rac, racsysdateRecently, some rac environments have been used to access sysdate and return the error time. This problem often occurs when the database link is created through Listener, and, in

Recently, we want to implement a business. We need to query the corresponding data in the Oracle Core database based on the table data in the SQL Server database, and then make statistics in the SQL Server database. therefore, we need to implement

To better understand the differences between the 10gR2 RAC and the latest version, we will continue to build a 10gR2 RAC on the platform with the Environment configured in 11gR2. Before installation, you must modify a Kernel Parameter of RHEL5.5 to

Oracle remote connection (PLSQL, SQL developement + Oracle database + client + remote connection settings, plsqldevelopement Server Configuration: oracle11g R2 x64 1. Set the listener A. Launch bar-> Start-> Program-> Oracle-OraDb11g_home1->

Method 1: Use sqlplus 64-bit: [Oracle @ qs-wg-db2 ~] $ Sqlplus/as sysdba;   SQL * Plus: Release 10.2.0.5.0-Productionon Sun Sep 25 08:57:22 2011   Copyright (c) 1982,201 0, Oracle. All Rights Reserved.     Connected: Oracle Database 10g Enterprise

The database version installed on my local machine is Oracle 11G R2. When I connect to the database today, the following error is reported: Oracle not available ORA-01034 ORA-27101-shared memory realm does not exist I found several solutions online,

64-bit win7 Oracle11gR2 database, win7oracle11gr2 I. Description To install the Oracle11gR2 database in the 64-bit Windows 7 operating system, we first need to download the Oracle database software, which contains the 32-bit and 64-bit Oracle

Oracle12c installation, connection, usage, etc. oracle12c Installation 1. oracle12c Installation See the following link: Http://jingyan.baidu.com/article/f96699bbab21c0894e3c1bf8.html 2. A ORA-12514 error occurred while connecting to the

Oracl X64 and plsql miscellaneous, oraclplsql First install orcal X64. Configure \ tnsnames. ora with orcal NetManger. After installation, use sqlplus to check whether the client has been installed. Enter sqlplus and prompt to enter the user

Install: Oracle installation has many tutorials on the Internet, which are explained in detail. I will not go into details here. I only provide two links, which may be helpful: Oracle Installation and simple configuration. free installation of

Use the sqlplus command line tool to create users and tablespaces for oracle, sqlplusoracle Creating tablespaces and users and assigning permissions using the Enterprise Manager or PL/SQL graphical method that comes with Oracle10g is relatively

Sometimes you may use SQLPLUS spool table data. How can you speed up the spool? SQLPLUS has a row prefetch Option In SQLPLUS, the default arraysize is 15. SQL> show arraysizeArraysize 15 It indicates that only 15 rows of records are transferred from

Today, when logging on to Oracle Data encountered a ora-01033: oracle initialization or shutdown in progress this problem, the company server database is 9i, using vm login on the server db and API have restarted the login or error, and then on the

Why is it possible to log on to the oracle database as sysdba and enter your username and password ?, Sysdbaoracle This is actually a problem with oracle database authentication.In the sqlnet. ora fileSQLNET. AUTHENTICATION_SERVICES =

Question: In my daily work, I think MySQL plus is used in 99% to log on to the database and manage, optimize, and configure the database. If there are many databases, all of them are unified SQL after connection>, it may happen that we do not know

How to deal with Oracle DataGuard archive log loss A database is configured with Physical Transaction uard (hereinafter referred to as dg). Because no check is performed, the archive day is deleted on the master database, and the slave database is