Oracle

Oracle database table Space usage query:Select B.file_name Physical file name,B.tablespace_name table Space,b.bytes/1024/1024 size M,(B.bytes-sum (NVL (a.bytes,0)))/1024/1024 has used M,SUBSTR ((B.bytes-sum (NVL (a.bytes,0))/(b.bytes) *100,1,5)

Create or Replace procedureFind_info (PIDinch Number) as --Defining incoming VariablesV_namevarchar2(Ten);--Define name VariablesV_salary Number;--Define wage variablesSqlstrvarchar2( $);--defining encapsulated SQL statement

differences and linkages between Oracle unique indexes and ordinary indexesDifference: Unique index and general index the biggest difference is that you add a single layer of constraint to the index column. A data column that adds a unique index can

When we use the Oracle database, suddenly power outages, causing a lot of problems, resulting in the loss of old data, affecting the correctness of the data, destroying the database. At this point, users desperately need to recover data. This

Test the stored procedure with the landlord:1. Right-click the stored procedure you want to testThe following prompt box appears2. Fill in the parameters3, click to start, the following actionsOver, that's so

First step: Login After root login, switch to Oracle user, enter Su OracleStep Two: Connect Under Oracle user, enter Sqlplus/nologStep Three: Use Administrator privileges Input Connect/as SYSDBAFourth step: Start/Close service Input StartupStartup

1. Log in with an Oracle userIf you want to install again, it's best to do some backup work first.Includes the user's logon script, the database automatically starts the closed script, and the listener automatically starts the script.If possible,

1. CMD on the Oracle serverExecutive LsnrctlExecute startAfter a long time, the prompt listener has been started.Perform status againIt was a long time before the command was executed successfully.It is best to find the cause because the

This article applies to CLOUD5/CLOUD6, first look at the DB operating system and database recommended by cloud:650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/7A/64/wKiom1aoaT6x_OuAAABe2tmsTNo161.png "title=" 21.png "alt="

This article is based on reprint:The Lpad function fills the string with the specified character from the left. Lpad meaning is filled from the left.The syntax format is as follows:Lpad (String, Padded_length, [pad_string]);String: Ready to be

The principle of database consistency reading for OracleIn an Oracle database, Undo has three main functions:provides a consistent read (consistent read), ROLLBACK TRANSACTION (RollbackTransaction) and instance recovery (Instance

The dual table is generated by default when each database is created, and the table has only one row.1) Analysis dual table execution, as follows:2) Application:In an Oracle database, the dual table exists as a virtual table because Oracle's query

As we all know, in the VMware virtual machine has a snapshot of the function, we can put the state of the system at this time to save, after the side of the non-measured events, it is good to restore the system. Similar functionality is also

Dbca cannot identify an existing database When you delete an unnecessary test database at the customer's site and use dbca, the database cannot be found. It's strange that it's starting !! Later, I searched for oratab in the operating system and

Add a disk to a data disk (asmexternal) 1. Create a disk and access both nodes. 2. Check the cluster status [grid @ rac1 ~] $ Crsctl status res-t release name target state server STATE_DETAILS restart Local Resources within ora. DATA. dg ONLINE rac1

Describes how to end the deadlock process in an Oracle database. 1. View deadlocks1) Use the dba user to execute the following statements select username,lockwait,status,machine,program from v$session where sid in (select session_id from

Oracle scheduled quick useQuick use of Oracle scheduled task: SQLServer has related scheduled tasks. You can directly open the task manager of SQL server to configure the scheduled tasks. The corresponding Oracle has a corresponding timing plan, but

Whether the Oracle service in Windows is a database name or SID Today, I first asked if the Oracle service in Windows is a database name or SID? I guess it's SID, but let's test it. Is that right? Start!   SQL> show parameter db_nameNAME TYPE

Oracle Database foreign key operations, oracle Database Foreign keys Racle uses a foreign key to limit the Field Values referenced in the subtable. The data in the subtable must exist in the primary table. When the record of the primary table

ORA-14400: INSERTED partition keywords are not mapped to any partition, ora-14400 keywords Problem description: When kettle is used to extract data from the original Library to the standard library, an error is reported during the extraction process: