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

Oracle only grants users the permission to access the view or table [SQL] -- Create the user create user LIMS_FSGL identified by "LIMS_FSGL" default tablespace VGSM_DB temporary tablespace TEMP2 profile DEFAULT; -- Grant/Revoke role privileges grant

Remote expdp network_linkEXP imp is often used to export data to oracle databases, but the efficiency and performance are not high. Many auxiliary functions are not powerful,For example, dynamic file segmentation is not good enough.The new expdp and

Connect to the ORACLE database through TunnelsSuppose there are two servers on the Internet, one is the application server (Linux), the other is the database server (win2003), and the two servers are in the same LAN (the same network segment ), you

ADD_MONTHS () What if the second parameter is decimal?We often use the ADD_MONTHS () function to obtain the date of a date after a few months. For example, we want to get the date after two months (January 1, April 05, 2013 ): chenZw> alter session

Creating a table in a complete Oracle table creation example is generally quite simple, but the Oracle table creation statements have many optional parameters, and some of them may not be used at ordinary times, I don't know how to use it when I use

Automatic Generation of batch execution of SQL scripts for batch processing scenarios: DBA has exported all the creation scripts for storage, functions, and other objects to me, with thousands of files. now, how do I import these object creation

Test the use of indexes for select statements in Oracle -- I have read many articles on SQL Optimization in Oracle and introduced a lot of cases where indexes are not used. I tested some cases when I was free today. -- Test Data create table EMP

Oracle index description-1. Index features: 1. By creating a unique index, You can ensure the uniqueness of each row of data in the database table. 2. Data retrieval speed can be greatly accelerated, which is also the main reason for index creation.

How to reconfigure the redo log location 1. shut down database shutdown2. use the OS command to copy redo log files to the new location mv/u01/app/oracle/oradata/MYNEWDB/onlinelog/o1_mf_1_89y70t1b _. log/home/o1_mf_000089y70t1b_test.log3. start the

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

[ORACLE basics 2] I am not familiar with cross-server table data synchronization in oracle, but I am now scheduled to perform two database tables for Synchronous replication. I don't understand it. I can only start to study and create it. If you

Rac10201 for RHEL5 Checking existence of VIP node application (required) Check failed solve today this 10201 for rhel5 is really killing me last step oracle cluster verfication utilityChecking existence of VIP node application (required) check

Listener error handling 1: Host Name and IP misplacement error message: [plain] [oracle @ odd ~] $ Lsnrctl status LSNRCTL for Linux: Version 10.2.0.1.0-Production on 01-MAY-2013 15:40:54 Copyright (c) 1991,200 5, Oracle. all rights reserved.

Oracle wait event-1. Knowledge about waiting events 1. The concept of waiting events from the source is introduced from ORACLE 7.0.12, with approximately 100 waiting events. In ORACLE 8.0, this number has increased to approximately 150, with

Oracle rac ssh equivalence configuration (I). To facilitate communications between nodes in the RAC environment, you must configure the SSH equivalence statement: when a user or program is connected from one machine to another without a password,

Instant Client for linux sometime for some reason, ex. you can't install on the host, not get the install package, or others. but you want connnect the oracle database via sqlplus only, in times you can use oracle Instant Client, the package very

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:

Select year, month, day, and quarter for the ORACLE time field -- get year, month, and quarter select to_char (date, 'yyyymmdd') DATE_ID, to_char (date, 'yyyy ') | 'Year' | to_char (date, 'mm') | 'month' | to_char (date, 'dd') | 'day' DATE_NAME,

Dataguard Online redo log and Standby redo log Dataguard classification: Physical Standby (Redo Apply) Logical Standby (SQL Apply) Dataguard protection mode: maximize performance (maximum performance mode) maximize availability (maximum available