Oracle

  The best way to master and use a tool is to master its principles first, understand its architecture, and then use it handy, or else use it, and don't know why this step does this, not to quickly locate the problem, let alone solve the problem

Oracle Database Sqldatabaseloggingfile –===================== – Manually delete the Oracle database –===================== In many cases, or unable to use the DBCA tool, we need to manually delete the database. This can be accomplished with the drop

The int type is a subtype of number type.The following is a brief description:(1) Number (p,s)This data type defines the data type, where p represents the total number of digits (the maximum number of bytes), and s represents the number of digits

--undo Table Space Summary--View all table space namesSELECT NAME from V$tablespace;--Create a new undo table space and set the auto-expand parameters;CREATE UNDO tablespace UNDOTBS2 datafile ' D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS02. DBF '

1. Automated Diagnostics Workflow:With an in-memory tracing tool that is always turned on, the database component can capture diagnostic data the first time a critical error failure occurs. A special repository, called an automated diagnostic

Oracle Memory ArchitectureThe basic memory structures associated with Oracle instances include:System global Area (SGA): shared by all servers and background processes. Examples of data stored in the SGA include cached data blocks and shared SQL

First, Oracle downloadNote that Oracle is divided into two files, and after downloading, two files are extracted to the same directory. In the path name, it is best not to appear in Chinese, and do not appear spaces and other irregular

=========================================================== Author: flysky0814 (http://flysky0814.itpub.net)Comment posted: 2007.11.28 11:14Category: oracle10gSource: http://flysky0814.itpub.net/post/35477/419443--------------------------------------

Occasionally need to understand, study this article, reprint recordFrom: http://blog.csdn.net/jxzkin/article/details/79496291. Create test data[HTML]? View Plain Copy CREATE? TABLE? Cc?? ?? (Student?) NVARCHAR2 (2), Course? NVARCHAR2 (2)

ASM SecurityThis section mainly describes the various security configuration topics related to ASM, such asConfigure ASM Required UserIDs, groupids;asm permissions such assysoper,sysdba and new sysasm permissions, and finally ASMUse the

method One: Use the TO_CHAR FM formatTo_char (Round (data.amount,2), ' FM9999999999999999.00 ') as AmountThe disadvantage is that if the value is 0, it will be displayed as. 00 instead of 0.00.Another note is that the number of decimal points to the

A similar test environment is installed because the customer database needs to be patched. You need to install 10.2.0.1 before upgrading to 10.2.0.5. Because I have a lot of articles about the installation, so this article only say the key steps, as

1. Download XE rpm package to your website2. Unzipunzip oracle-xe-11.2. 0-1.0. x86_64.rpm. Zip3. Convert RMP Package to Deb package, alien install Apt-get if not alien. To install or update libaio1, you must. 1 cd Disk1 2 alien--scripts

Simulate tree-like processing of Oracle neighbor models in MySQLDatabases have many processing models for hierarchies. You can design models based on your needs. Of course, the simplest and easiest model to design is the so-called adjacent model. In

SQL advanced (1) -- regular functions, SQL -- Functions When we compare and process strings, the like clause may be used at most. % Represents one or more characters, and _ represents one character. However, when processing complex strings, we find

Oracle query Character Set, Oracle Character Set Select * from nls_database_parameters Forget it. How to view the character set of the Oracle database, detailed operations, xx Database Server Character Set select * from nls_database_parameters,

Event-based scheduling in ORACLE Scheduling (2) [developed by weber], oracleweber I. Review Scheduling is divided into time-based scheduling and event-based scheduling. For a brief review of the preceding information, see ORACLE time-based

Use of fine-grained oracle Auditing Take the scott user's emp table as an Example ---- Add a policy Begin DBMS_FGA.ADD_POLICY ( Object_schema => 'Scott ', Object_name => 'emp ', Policy_name => 'mydomainy1 ', Handler_schema =>

2. solutions when oracle cannot be connected to a virtual machine using a windows ClientWhen the virtual machine can connect to the local machine, but the remote connection is still unavailable, add rules in the firewall at this time: A: Log On As

Use of oracle collections of IT Ninja Turtles Each query group can obtain its result set. to combine multiple query results into one result set, you can use the set operation. Such as UNION, UNION, unoin all, INTERSECT, and MINUS ). The purpose of