Oracle

Delete the archive log from ASM in case of ORA-15028 error today at to the gold check data, found that the recent library (AIX6.1 4 nodes 11gR2 RAC) Archiving is full, database hang, I ran to ask the middleware buddy who arrived in advance and found

The definition of the oracle view learning summary view is the query statement it uses. Oracle stores this definition in the data dictionary as text. When you reference a view in an SQL statement, Oracle performs the following operations:

How to deal with oracle tablespace insufficiency -- 1. view the table's select tablespace_name, table_name from user_talbes where table_name = 'test'; -- 2. Obtain the user's default tablespace select username, DEFAULT_TABLESPACE from dba_users

Online redefinition tables ORACLE databases support online (off-database) Modification of various physical and logical attributes of a table, including partitions, tablespaces, adding columns, deleting columns, and changing a table to an IOT table.

Statement [SQL] USE MyTargetDB go IF object_id ('wfp _ before_add_password_backup ') IS NULL SELECT o. name AS proc_name, s. definition INTO tempdb. dbo. wfp_before_add_password_backup FROM sys. SQL _modules s, sys. objects o WHERE o. object_id = s.

Note the problem of executing marker_setup. SQL hang during ogg ddl replication configuration: this is a record. During the ogg experiment, configuring DDL replication and running the marker_setup. SQL script hang is not a pure technical problem,

Steps for canceling the deadlock check code and canceling the deadlock session in the EBS backend --- Experience 1. General process for handling request congestion: 1. Execute cc_post_hang. SQL in PL/SQL (to Tao ); [SQL] -----------------------------

Select * from all_tab_comments; -- select * from user_tab_comments; -- Query all tables and views of the current user. select * from all_col_comments; -- query the column names and comments of all tables of the current user. select * from

In the query statement, select from where group by having order by is executed in sequence 1. the query mainly contains six keywords, and their order is select -- from -- where -- group by -- having -- order by, where select and from are required,

Why Does Oracle sometimes use indexes to search for data? A: When you use the SQL language to publish a query statement to the database, Oracle will generate an "Execution Plan", that is, the data search scheme through which the statement will be

Oracle_DAY 01 operation statement SQL> enter the oracle operation environment to query data -- DB -- orders Table External table is the basic unit of data storage in the database. The basic unit of data storage in the table is a row of table

Oracle_DAY 02 operation statement where clause ----- limit row return 1. if the data that meets the where condition is returned, if the where condition is not met, the first_name with the query salary greater than 1200 is filtered out. salary select

Ora-00257 errors and oracle Character Set sqlplus/nologconn charge/charge cause ora-00257 errors are generally caused by an archiving log storage directory full and archive failure. // * Cause: The archiver process has ed an error while trying to

In Oracle, when auto-incrementing sequence is reset to initial 1, it is deleted and rebuilt. This method has many drawbacks, functions and stored procedures dependent on it will become invalid and need to be re-compiled. However, there is a clever

Error in invoking target 'client _ sharedlib 'of makefile'/u01/app/oracle/product/10.2.0/db_1/network solution yesterday afternoon, when you receive an application, you must set up 10.2.0.1Rac for RHEL5 in an unlimited number of digits and use the

Several Policies of Oracle Tuning Log File Sync wait event have problems in a frequent commit/rollback or disk I/O, and a large number of physical read/write contention, so we will often see LOG FILE SYNC wait event the metrics for evaluating log

A series of common Oracle operations 1. create an Oracle tablespace: Example: create tablespace my_space datefile 'd: \ ruanjian \ app \ Administrator \ oradata \ oracle \ my_space.dbf' size 20 M; 2. delete Oracle tablespace: Example: drop

Watch the Oracle video note of Shang xuetang 1. go to sqlplus: Method 1.c:\ Users \ Dell> sqlplus sys/sys as sysdba; method 2.C: \ Users \ Dell> sqlplus/nolog/* Start sqlplus */SQL> connect sys/sys as sysdba; /* connect to the database */method 3.C:

Sqlplus environment configuration (login. SQL) in Oracle, two files can be used to set the SQL * Plus environment: (1) Global setting file: $ ORACLE_HOME/sqlplus/admin/glogin. SQL (2) Personalized setting file: login. SQL, and then the operating

The entire process from software installation to running in Oracle 1. When the software is just installed, there is only a bunch of software, and no database-related files and content are generated. 2. sqlplus/nolog connects to the database software