Oracle

Rights Management1, default of three users2, create user3, Authorization, REVOKE permissions4, System permissions and object permissions5, role6, Manage permissions by role7. How to pass the permission, lose the administrator password3 Default

1.1.1. RMAN-06556Date: 2014-05-21 16:33Environment: Test environment"Scenario description"A full-library backup was performed using Rman, but an error was encountered during an incomplete recovery, prompting that a data file must be recovered from a

-- Create a tableCreateTableJobtest (IDVARCHAR2( -)PrimaryKey,NAMEVARCHAR2( -), age Number(3) )-- create a stored procedureCreate or Replace procedure jobtestprocedure isbegin Insert into jobtestvalues(to_char (sysdate, ' yyyy-mm-dd hh:mm:ss '),'

Select Ten + ten from dualThe result is 30, no problem at all.Select Null + ten + from dualThe result is an empty string, but the expected result is 20.Select NVL (null,0) + ten + from dualThis results in a processing of 20. If the query has a null

Tag: c A CTI Line name table1.SELECT * FROM (SELECT * to tablename ORDER by Dbms_random.value) where rownumNote: Dbms_random is a package that can generate random numbers or strings. Value () is the most commonly used, the use of value () generally

Here is a test, in which the library creating the database link is XJ (WINDOWS 2003 Oracle 10g 10.2.0.1), the linked library is Dmdb (LINUX AS5 Oracle 10g 10.2.0.1 RAC)Part I: How to create a DblinkThere are two ways to create Dblink:1. Configure

The data in Oracle is backed up.Description:Usage Prerequisites:The Oracle client needs to be configured.Function:Back up the Oracle database.DescriptionNewly backed up database in the backup directory, the last backup is stored in the Old_backup

Set Archive mode (Mount status)ALTER database ARCHIVELOG;//Close the databaseshutdownImmediate//start Database to mount State startup MountAlter DatabaseArchivelog;//View archive Status ArchiveLoglist; SQL>ArchiveLoglist; database log mode archive

Example (instance)An instance is a non-fixed, memory-based basic process and memory structure. When the server shuts down, the instance does not exist.Databases (database)Database refers to fixed, disk-based data files, control files, log files,

During the monitoring process of the background database of a news website, the database often starts to use swap partitions, which leads to slow response of the entire application system and failure to provide services. The server memory is 8 GB,

SQL> select * from v $ version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionPL/SQL Release 11.2.0.1.0-ProductionCORE 11.2.0.1.0

1. Transaction Introduction Transactions in Oracle11g are automatically started implicitly and do not need to be executed by the user. However, for the end of the transaction, You need to perform the specified operation. Generally, Oracle considers

Although the table has been created, it cannot be checked whether the data in the table is legal. If you want to filter the data in the table, you can use the constraints, the main function of a constraint is to ensure the validity of the data in

1. If oracle 11g is installed on linux, the following error occurs: INFO. $./RunInstaller after the command is executed, a dialog box with an error message is displayed. The content is very simple and only contains the words "INFO: INFO ". 2. view

Those who often write SQL should be exposed to oracle date and time functions. For example, financial software or human resources software should be collected every year, quarter, month, or even Week. Today, I am free to wait. I specially sorted out

-- Create a table Createtable JOBTEST (IDVARCHAR2 (50) primarykey, NAMEVARCHAR2 (20), age number (3 )) -- Create a stored procedure Createorreplaceprocedure jobtestprocedure Isbegin Insertinto jobtest values (to_char (sysdate, 'yyyy-MM-dd hh: mm: ss'

1.1.1 RMAN-08138 Date: Environment: test environment [Scenario description] On the test machine, when RMAN is used to delete archived log files, a WARNING is prompted, and archive logs cannot be deleted. [Error message] RMAN> delete archivelog all

1.1.1 ORA-19573 Date: Environment: test environment [Scenario description] When the database instance is in the OPEN state (read write), an error is reported when the database restoration and restoration operations are performed in RMAN. [Error

Chapter 2 asm instanceasm instance type: After 10 Gb, an ASM type is added to the ORACLE instance type. Set the parameter INSTANCE_TYPE = ASM.ASM instance startup command: startupNomountStart the instance and background process, but no disk group is

1. To better understand the differences between the two, see the following table:UNDO REDO Record How to undo a change How to reproduce a change Used Rollback, Read-Consistency Rolling forward DB Changes Stored