Oracle

View cluster node status The command is olsnodes.-I displays the VIP for each node,-N Displays the number of each node in the RAC cluster-P Displays the private IP address used by each node-S shows the status of each node (activive or inactive)

1 How do I see what tables are in the database?SELECT * from Sys.user_tables;2 How to link a databaseSqlplus/nolog;conn sys/oracle as SYSDBA;3 How to start a databaseStartup4 Viewing the Oracle instance structureDesc v$instance;5 Viewing the user's

1, table access mode optimization: a) Common table first "index Lookup index Scan" to avoid full table scanIn most scenarios, it is much more efficient to scan through index Lookup indexes than full table scan (FTS). When writing SQL, in order to

Today, nothing to do, on a database to play, by the way to summarize under0, cmd command Administrator permissions to log into the databaseSqlplus/as SYSDBA1. cmd connection to remote databaseSqlplus Xn_balance/[email

Thinking back just entered the job, a server was hung up, so is in "distress" have the opportunity to learn. In the dead of night, I want to recall the creation of an Oracle instance. One method, DBCA, a graphical interface, but relies on software

DECLARE CURSOR C1 is select table_name from User_tables; V_table_name User_tables.  Table_name%type;  V_CNT number; V_sql VARCHAR2 (2000); BEGIN for V_table_name in C1 loop v_sql: = ' select count (1) from ' |

I. Log in to Oracle using SYS user(1) Run-cmd-sqlplus-sys/password @ Connect character as SysdbaIi. Delegation of authority1, Grant Ctxapp to full-text search user use;2. Grant execute on Ctx_dll to full-text retrieval using the user;3. Full-Text

Oracle Installation text tutorial in VMware linux environment (1), vmwareoracle Installation Process: Preparations ---> install ORACLE software ---> install and upgrade patches ---> install odbc to create a database ---> install listeners --->

How to install ORACLE silently In this experiment, I copied the previous virtual machine directly, deleted the oracle installed on the graphical interface, and re-installed it. Therefore, I need to modify some configurations here. First, modify our

JDBC connection to Oracle Database I remember when I was in my sophomore year, we took a java course. At that time, the teacher said JDBC, and I didn't know how to learn it well. Until now, I didn't know what JDBC was, I know that this stuff can

ORA-00214: controlfile '/u01/app/oracle/oradata/[sid]/control01.ctl 'version inconsistent with file'/u01/app/oracle/oradata/[sid]/control03.ctl ', oraclecontrolfile Sample error: SQL> startupORACLE instance started. Total System Global Area 285212672

Rownum, row_number (), and rownumrow_number in oracle This section briefly introduces how to use rownum and row_number () in oracle and provides an example. Reference: http://www.cnblogs.com/zjrstar/archive/2006/08/31/491090.html First, we will

In-depth analysis of which services must be enabled for Oracle 11g, oracle11g After successfully installing the Oracle 11g Database, you will find that your computer runs slowly, and your computer with low configuration may even experience very bad

A detailed description of services and services that must be enabled for Oracle 11g, oracle11g After successfully installing the Oracle 11g Database, you will find that your computer runs slowly, and your computer with low configuration may even

Create a new user and modify the maximum number of connections at oracle11g Create user test identified by root; grant create session, resource to root; alter user test account unlock; grant create view to test; grant any sequece to test; grant

Oralce11g registry uninstall 20140810 Windows Registry Editor Version 5.00[-HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE][-HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle in

Oracle transaction processing and instance demonstration jdbc operation batch DeletionTransactions As the basic unit of logical processing, database operations are composed of one or more SQL statements. Of course, there are also non-database

ORACLE learning notes-create a user and a table, and create an oracle learning note I. User-related SQL statements /* Create a user */ create user SA identified by 2013; Description: SA user name and 2013 Password /* Authorize connect, resource to

ORACLE Study Notes-query articles, ORACLE Study Notes- 1. Common Query /* Query table data */select * from STU /* Retrieve the first three rows of Data */select * from stu where ROWNUM /* Fuzzy query */select * from stu where stu_id like 'stu001%'

DBA installation of Oracle Database11g database graphic tutorial in Linux, dbadatabase11g Oracle11g is a common version. It is a pity that it failed to try to install Oracle 12c.The following documents are prepared: 1. Connect to the Installation