Oracle

How to Use the oracle impdp network_link parameter 1. Environment Description source database: www.2cto.com IP Address: 192.168.137.100 sid: catalog Username: rman password: rman target database: IP Address: 192.168.137.101 sid: orcl Username: rman

The Oracle collection has no initialization exception investigation. The SQL code www.2cto.com set has no initialization exception investigation. -- Created on 2010/11/02 by WANGNAN declare -- Local variables here I integer; TYPE t_table IS TABLE OF

How to configure database Oracle # TNSNAMES. ORA Network Configuration File: C: \ oracle \ ora90 \ network \ admin \ tnsnames. ora # Generated by Oracle configuration tools. www.2cto.com ORACLE90 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL

Comparison of decode and case when in oracle the following example uses the decode of the emp table in oracle as follows: www.2cto.com DECODE (col | expression, search1, result1 [, search2, result2,...,] [, searchn, resultn,...,] [, default])

Oracle views authorization and data dictionary views oracle views authorization: www.2cto.com all_tab_privs. the grantor grantee Authorizer TABLE_SCHEMA table is in which mode the TABLE_NAME table name PRIVILEGE grants the GRANTABLE permission.

Oracle FGA preliminary fine-grained audit (FGA) is introduced in Oracle 9i. It can record SCN numbers and row-level changes to recreate old data, however, they can only be used for select statements, but not for DML, such as update, insert, and

The dbconsole service of the OEM console cannot be started. It is a very annoying event for those who use the Web to manage Oracle databases. I believe many of them have encountered such troubles. Www.2cto.com cannot start the OEM console. an error

Oracle index statement sorting 1. create an index www.2cto.com create [unique] index index_name on table_name (col_1, col_2 ,...) tablespace tabspace_name; 2. alter index index_name pctfree 30 storage (initial 200 k next 200 k); 3. manually assign

Oracle Database Access to the local area network of oracle11 is not feasible. In the case that the local area network cannot access the oracle database for three times, the entire R & D department is basically unable to do things. Www.2cto.com is

The following statements are used to query all user tables in Oracle. If you are interested in Oracle queries, take a look. Www.2cto.com select * from all_tab_comments -- query tables and views of all users. select * from user_tab_comments -- query

PL/SQL is similar to SQL Sever in importing excel data. It is used to find a function to import excel Data. follow the steps below. The following is a detailed process, hoping to help cainiao like me. Www.2cto.com 1. Prepare an excel worksheet.

Why Does Oracle reinstall and recover data: there are various problems with the Oracle database used for development at www.2cto.com, which may be difficult to adjust. Reinstallation, but you want to keep the data file. Solution: 1. back up the

When creating a table in oracle, you must first Delete the table. oracle syntax does not include the drop table table_name if exists form in mysql syntax, but we can save the country by using the orale stored procedure to achieve the same effect,

Change tablespace for INDEX 1. normal caseALTER INDEX index_name rebuild TABLESPACE tablespace_name; www.2cto.com 2. index with partitionIf TABLESPACE_NAME is null, which means the index has been partitioned. SELECT TABLESPACE_NAME,. * FROM

Oracle Database uses SQL to implement quick paging. Oracle uses nested layer-3 query statements and rownum to implement paging. This is the fastest way in Oracle, if only one or two layers of query statement rownum cannot support order. Www.2cto.com

Oracle imp import to the specified tablespace 1. create tablespace example_tablespace datafile 'e :\****. dbf 'size 10 m reuse autoextend on next 1 m maxsize unlimited; www.2cto.com 2. create user username identified by password default tablespace

What does sqlplus/nolog mean by sqlplus Command Format: www.2cto.com usage: SQLPLUS [[] [] [] Where :: =-H |-V | [[-M ] [-R ] [-S] :: = [/] [@ ] |/NOLOG :=@ [. ] [...] "-H" display SQL * Plus version labels and Syntax "-V" display SQL * Plus

Authorization of oracle learning records (1) oracle learning records, Table query and execution of Stored Procedure authorization, and use of grant statements for reference. Www.2cto.com [SQL] -- use the sys user to connect to the database and

Oracle Learning Record authorization (2) oracle Learning Record and authorization. New Requirement: grant the query permission of all tables of a user to another user. Authorization using oracle learning records (1) Table-by-table authorization is

Oracle ASCII string in hexadecimal SQL, you can directly insert data represented by hexadecimal strings to blob tables. If it is not a hexadecimal string, pl/SQL reports an invalid hexadecimal number exception. Www.2cto.com ASCII string ==>