Oracle

ORA-01033: ORACLE initialization or shutdown in progress problem ORA-01033: ORACLE initialization or shutdown in progress solution: Command Line: sqlplus "/as sysdba" entering sqlpluswww.2cto.com SQL> shutdown normalORA-01109: the database has not

Oracle distinguishes materialized views from tables before 9i at the beginning of 10g. Many functions do not distinguish between tables and materialized views. After 10g. Many features differentiate tables from materialized views. The common comment

Oracle switches undo tablespace 1. create an undo tablespace SQL> create undo tablespace undotbs2 datafile 'e: \ oracle \ product \ oradata \ orcl \ un dotbs02.dbf' size 10 M autoextend on next 10 M maxsize 500 M; 2. since undo_tablespace is a

How to disable and enable automatic statistics collection for oracle 10g 1. Oracle 10g automatic statistics collection-Automatic analyze starts from oracle Database 10g, after creating a database, Oracle creates a scheduled task named

WMSYS. the usage of the WM_CONCAT function is provided by the WMSYS. the following is an example of how the WM_CONCAT function can complete row-to-column conversion: 1. prepare data: SQL code create table testtable (id number, name varchar2 (30);

Once the database fails to be installed, it is very troublesome to uninstall it. After collecting data from various aspects, we will summarize the methods for uninstalling oracle databases. I tried it. OK. 1. It is very easy to uninstall Oracle on

What is Undo used? Before introducing undo, let's talk about another thing transaction, which is translated into transactions or transactions. We need to apply for many resources in the process of a transaction, and a complicated transaction also

Oracle common data dictionary 1. query all tables under a user select table_name from all_tables where owner = 'Scott '; 2. query all fields (columns) in the EMP table) select * from all_tab_columns where table_name = 'emp'; www.2cto.com 3. select *

Summary of oracle simple learning (6) -- database transaction links: oracle simple learning Summary (1) -- sqlhttp: // www.bkjia.com/database/201210/159545.html#oraclesimple learning Summary (2) -- Query Summary (3) -- function compute (4) --

The basic principles of Oracle TCP/IP connection here is the most common situation on the Network: a network-based connection request is recommended for TCP/IP connections. In this case, the customer is on one machine, and the server is on another

The data dictionary provided by Oracle is used to store database information. The data dictionary can be used to understand the internal information of the Oracle database, for example, the table creator, creation time, tablespace, and user access

Flash_recovery_area space pressure causes ORA-01033: ORACLE is initializing or disabling the problem as follows: SQL> conn/as sysdba is connected. SQL> conn hr/hrERROR: ORA-01033: ORACLE initializing or disabling warning: you are no longer connected

Oracle loop Statement 1. Exit When LOOP: www.2cto.com SQL code declare -- Local variables here I integer; begin I: = 0; LOOP Exit When (I> 5); Dbms_Output.put_line (I ); i: = I + 1; end loop; end; 2. Loop Java code declare -- Local variables here I

How to locate what you don't know: especially to know which view to query. If I want to check what is related to role, I rely on dba_objects, so: SQL> select object_name from dba_objects where object_name like '% ROLE %'; www.2cto.com OBJECT_NAME

Change the port number C: \ Documents ents and Settings \ hesai> sqlplus SQL * Plus: Release 10.1.0.2.0-Production on Saturday October 20 15:16:37 8080 Copyright (c) 2012 4, ORACLE. all rights reserved. www.2cto.com Enter user-name:/as sysdba

Many people think that Oracle can easily change the password but cannot change the username. actually, the name can be changed. it is a little troublesome to change. the use of username change is useful in such a scenario. assume that a company has

Oracle Record type Introduction 1. What is Record )? A composite structure composed of scalar values of multiple columns in a single row. It can be seen as a user-defined data type. It is similar to a multi-dimensional array. Encapsulate one or more

Oracle Database learning-basic structure popularize basic knowledge of oracle. To sum up, oracle is composed of instances and databases. The structure is as follows: www.2cto.com the oracle database consists of instances and databases: * The

Oracle em cannot start solve sysman, dbsnmp password modification: www.2cto.com 1, SYSMAN Password Change 1, stop dbconsole [oracle @ xxx ~] $ Emctl stop dbconsole check the status and confirm that dbconsole has stopped [oracle @ xxx ~] $ Emctl

Oracle trunc truncation date function truncation Date: www.2cto.com first run the command: alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: hh'; capture today: SQL> select sysdate, trunc (sysdate, 'dd') from dual; sysdate trunc (SYSDATE,