Oracle

oracle| Data | database | Performance Oracle is a high-performance database software. The user can adjust the parameters to achieve the optimization of performance. Performance optimization is mainly divided into two parts: first, the database

oracle| problem 51. How do I put a small table in a keep pool?　　ALTER TABLE XXX storage (buffer_pool keep);　　52. How do I check if a patch is installed? Check that Orainventory 53.　　How do I make a SELECT statement automatically generate ordinal

oracle| Data | database | speed | statistics Large database systems often need to use query statistics, but for large data systems, users in the complex query statistics often feel the speed is very slow, can not meet the application requirements,

oracle| Data | database 1, view the table space name and size Set linesize 140;set pages 200;column tablespace_name format A30;select tablespace_name,min_extents,max_extents,pct_ Increase,status from Dba_tablespaces;select

oracle| Recovery | data | database First, user table space Error: ORA-01157,ORA-01110 or operating system-level errors such as ORA-07360 when you start the database will cause an error immediate when you close the database (using shutdown normal or

Oracle 1. What is called a bare device? A bare device, also called a bare partition (raw partition), is a special character device that is not formatted and is not read by UNIX through a file system. It is the responsibility of the application to

oracle|unix| Data can unix Oracle 10g read file data with Utl_file packets? I am under Window Oracle 8i using Utl_file can read the data of text files, I test through, But not on Unix Oracle 10g! Error! Begin Loadfiledata (' D:\ora ', ' 1.txt ');

oracle| Statement----------------------------------------------------------------------------------- CREATE table ----------------------------------------------------------------------------------- CREATE TABLE Bak_dba_tablesapce (Ddl_txt varchar2 (2

Oracle [Oracle 10g] tablespace renamed Author: fenng Date: 24-oct-2004 Source: Http://www.dbanotes.net Version: 0.1 Simple Introduction In previous versions of Oracle 10g, changing tablespace names was almost impossible, unless deleted, recreated,

Js|oracle| stored procedure Novice in the writing program, must be adventurousness, and must have patience, do not compromise, do not understand on the book, online search data, ask friends, resolutely carried out in the end. Recently has been with

Oracle's classic Oracle books: Effective Oracle by-by Thomas Kyte Tom's another classic, in this book, Tom proposed a DBA should not be a fireman, but should be able to prevent problems from the source of the emergence of ... The following

Oracle Software Environment: 1. Windows 2000+oracle 8.1.7 2, the ORACLE installation path is: C:\ORACLE Implementation method: 1. Start-> Setup-> Control Panel-> Admin Tools-> Service Stop all Oracle services. 2, Start->

oracle| string --intercept the most likely mixed string in Chinese and English according to the given byte length to avoid a half character problem Create or Replace function SUBSTR_GB (str_ varchar2, Begin_ Integer, Length_ integer) return varchar2

oracle| Safety | Problem database security problem has always been one of the focus of attention, we know that a business or organization of the database if the hacker attacks, and these databases and the preservation of very important data, such as

oracle| Data | data type Data type parameter description char (n) n=1 to 2000 byte fixed-length string, n-byte long, if not specified length, default to 1 bytes long (a Chinese character is 2 bytes) varchar2 (n) n=1 to 4000 bytes variable long

Oracle-CREATE TABLE (creating a partition Table) CREATE TABLE Bill_monthfee_zero ( SERV_ID number is not NULL, Billing_cycle_month Number (6) is not NULL, Date_type number (1), ACC_NBR VARCHAR2 (80) ) Partition by range

oracle| Security | data (ii) Another hidden danger from the inside--user management and password issues Here, in fact, as a similar point of the database administrator is very clear, the Oracle database itself has used a number of ways to enhance

oracle| Backup | notes | recovery User-defined database backups Type of Backup Backup methods Example Data files Operating system commands or tools C:\COPY Datafile1.ora Datafile.bak Archive Redo log files Operating system commands or tools

oracle| temporary table We have recently taken into account the fact that our database-side write stored procedures are used in temporary tables because we It is not clear how the database end is handled, and how SQL Server is handled The same,

1, must set the undo retention time is large enough to be able to reconstruct the required flash back data The ALTER SYSTEM SET undo_retention= seconds value is the number of seconds that the UNDO data is persisted. Flashback view is