Oracle

An old test AIX server was ignored. Recently, Oracle was full. Cleaned up. Version: Oracle 10gR2 for AIXSymptom: SQL> alter database open;alter database open*ERROR at line 1:ORA-16014: log 3 sequence# 157 not archived, no available destinationsORA-00

When form has a ora error, you can use the following method for query errors such as opening form encountered FRM-40735: WHEN-BUTTON_PRESSED exception: ORA-040631, enter database, enter oerr ORA 04063 [oratst2 @ oracletest ~] $ Oerr ORA 1, 0406304063

The original understanding of the index only knows that the index can be based on one or more columns. The B-Tree index does not contain null, however, in some cases, we need to use the where column name is null to find some data. At this time, the

Some big tables are sometimes used in my experiments. Here we will share how to use dba_objects to create and test large tables: First, create a test table. SYS @ ORCL> create table test nologging as select rownum id, a. * from dba_objects a where 1

A few days ago, we created vmware, installed oracle10g Database, and imported SQL scripts in the project. All Chinese characters are garbled. Now we will sort out the online answers for your reference: 1. query the current character set of the

Today is. Learn the basic acfs knowledge. Oracle acfs introduction:Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a multi-platform, scalable file system, and storage management technology that extends Oracle Automatic

Not all data files can be recovered. For example, if the data files in the SYSTEM tablespace are lost or damaged, the SYSTEM tablespace is restored directly unless backed up. If it is a temporary tablespace, You can recreate it. 1. Confirm

Oracle involves the query statement of a table. If it is the first execution, that is, hard parsing, the steps to be executed involve the following objects: Tables # Queries Purpose Access $1 Permissions used by a dependent object against its parent

1. Create full database backup 2. Construct test data under the test2 user 3. Simulate file loss: log on to and close the database as sysdba, and try to restart the database. 4. Execute recovery: Enter the RMAN command line Environment

I. rman Configuration1. Go to rman: rman target/in CMD/2. Check whether the file is in archive mode: SQL> archive log list; (rman must run in archive Mode)3. Enable the archive mode:Copy codeThe Code is as follows:SQL> shutdown immediate;SQL>

Note: The catalog directory must be used to create a database for restoration.I. catalog backup1. Create a tablespaceCopy codeThe Code is as follows:SQL> create tablespace rman datafile 'C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ rman01.dbf'

Solution:Modify the environment variable file of an oracle user. Add NLS_LANG = "SIMPLIFIED CHINESE_CHINA.al32utf8"; export NLS_LANGCopy codeThe Code is as follows:[Oracle @ rhel6r4 ~] $ Vi. bash_profile#. Bash_profile# Get the aliases and

1. Primary Key and foreign keyPrimary Key: a record in a relational database has several attributes. If one attribute group (note that it is a group, it can be one or multiple), it can uniquely identify one record, the attribute group is the primary

Oracle environment variable settings in window server 1. Right-click my computer and choose Properties> advanced> environment variable"2. Select "Path" and click "edit". Add a semicolon ":" to the end of the variable value text box of "Path". then

Hierarchical relationship: server. database. schema. object The client connects to the database through an instance. When using an instance, SQL server must use the login name (for example, the default sa ). A login name can be mapped to the user

Index unique scan requires at least 1 logical read compared to index unique SCAN, this is because the unique row scan of the index clearly only has one row of data to be returned, while the index range scan may have multiple rows of data to be

Today is. During the database performance tuning process, I suddenly moved to the previous email with the following information: From the log, it is found that there is a row-level exclusive lock contention, resulting in a deadlock. Problem

--- Indicates flashing back to the database --- Use a flashback table to restore the table content to a specific time point in the past --- Restore from the deleted table --- Use the flashback query to view the database content at any point in time -

The client-side TAF configuration was introduced last time, but the client-side TAF configuration also has its limitations, that is, the tnsnames needs to be configured on each client. configuration is required on ora. If the configuration is

SQL> create table aa (a number, B number );Table created.SQL> create table bb (B number, c number );Table created.SQL> insert into aa values (1, 2 );1 row created.SQL> insert into aa values (2, 3 );1 row created.SQL> insert into bb values (2, 4 );1