Oracle

// Create a temporary tablespaceCreate temporary tablespace test_tempTempfile 'e: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf'Size 32 mAutoextend onNext 32 m maxsize 2048 mExtent management local;// Create a data table

The function is very simple. If a field has more points, one more parameter will cause problems.For example:Too partition columns. Recently I have read the web js optimization. js conventions for internal variables start with _, for example, _ name,

When I was doing a project, a colleague accidentally duplicate all the data in a table while importing data. That is to say, all the records in this table have a record. This table has tens of millions of data records and is a production system.

The index is like a dictionary directory. With the dictionary directory, we can quickly find the entries we need. The same is true for databases. With the Oracle database index, related statements can quickly locate the record location without

Create and Manage UsersOne of the most basic management requirements of databases is to identify users. Each user connected to the database should have a login account.Shared accounts are difficult to troubleshoot and audit, and they have little

    This week I learned about the Oracle architecture.       The Oracle system consists of two major parts: SGA (system global zone) and PGA (Program global zone ).   SGA mainly includes database buffer cache, shared pool, redo log buffer, large

Generally, after a transaction is committed, its changes are persistent. Even if the database crashes after submission, the changes are permanently stored in the database.However, there are two exceptions:1) Use the WRITE extension added by the

My system is win7 32-bit flagship Edition Oracle 10g 2nd is installed Step 1: Modify the two refhost. xml files in the installation file directory in the db \ Disk1 \ stage \ prereq \ db and \ db \ Disk1 \ stage \ prereq \ db_prereqs \ db

ORA-01653: Table space expansion failure issues---- Query table space usage ---Bytes ------------------------------------------------------------------------------------------Select upper (F. TABLESPACE_NAME) "tablespace name ",D. TOT_GROOTTE_MB

Stored Procedure: a collection of SQL and PL/SQL statements. I think it is similar to the Java method.1. Examples of the creation process:Create or replace procedure mypro (did in varchar2) -- create a stored procedureIsName varchar2 (10); -- the

Check the location of the data file as follows: SQL> select name from v $ datafile; NAME--------------------------------------------------------------------------------/U01/app/oracle/oradata/marven/system01.dbf/U01/app/oracle/oradata/marven/undotbs1

1. Listener Overview: Processes running on the database server are used to detect and accept the queried network. You can use listener to monitor the control and interact with the listener. the listener's job is to listen to the network, when a

1. Compared with the original method, trigger/Job + DBLINK can be synchronized and refreshed regularly.2. materialized view refresh modes: Incremental refresh and full refresh.3. Advanced Replication: Multi-master replication and materialized view

Sometimes this problem occurs. We need to query a table and sort it by business. For example, I need the following results: Region date fee product no. User No. 290 201202 258 1 s1290 201202 200 1 s5290 201202 100 1290 201202 90 2 s7290 201202 88 2

Operating System: OracleLinux 6.1 32-bit Database: Oracle11.2.0.3   Because the Patchset after the Oracle 11g can be directly used for installation, I also directly installed it into 11.2.0.3, which saves the trouble of upgrading, during which two

Author: skateTime: 2010/09/07 Resetlogs mechanism of oracle I think everyone is familiar with the alter database open resetlogs command. Have you ever wondered why this resetlogs option should be used? When will it be used?What is its mechanism?

[SQL] [SQL] set operator: UNION/union all union set, INTERSECT intersection, MINUS difference set 1. union is used to calculate the union. The public part only contains oneFor example, find that the name of the emp table contains 'A' or 'M'SQL>

Note: rownum starts from 1; 1. rownum sorts records according to the order when inserting records, so be sure to pay attention when there is an order by clause! 2. When the rownum and order by fields are used, what is the impact of the primary key? 3

How to determine whether Oracle RAC method 1 has been implemented: RACSQL> show parameter cluster_database; name type value implements ------------- -------------------------------- cluster_database boolean TRUE cluster_database_instances integer 2

Oracle uses SQL to obtain database tables and table fields -- Method 1: Query dba_tab_columnsselect COLUMN_NAME, DATA_TYPE, DATA_LENGTH from dba_tab_columnswhere table_name = upper ('table name') order by COLUMN_NAME -- This method requires DBA