Database Administrator

One of the new features of Oracle 12C, You can rename the data file online. Before Version 12c, if a data file is created and put in the wrong directory, or is originally put in asm, due to the missing plus signs, and so on, in the file system, you

Note: It is well known that spfileSID will be searched under $ ORACLE_HOME/dbsx when the Oracle database is started. the ora file starts the system based on the parameters configured above. I believe many shoes have been opened, configured, and

Oracle unlocking resolves the ORA-00054: Resource busy Error 1. Procedure:-- 1. Get the session_id of the locked objectSELECT session_id FROM v $ locked_object;-- 2. Obtain the sid and serial of the v $ session through session_id #SELECT sid, serial

In the last two days, I have always been running out of the house. I cannot guarantee the time at the company. So I want to get an Oracle on my own machine to help the customer solve some problems. Of course, this is my small broken notebook, which

MyBatis 3.2.6 there are two ways to obtain the auto-incrementing primary key when inserting Take MySQL5.5 as an example: Method 1: Insert into person (name, pswd) values (# {name}, # {pswd }) Method 2: Select LAST_INSERT_ID ()Insert into person

Error locating: SQL>! Oerr ora 01002.01002,000 00, "fetch out of sequence"// * Cause: This error means that a fetch has been attempted from a cursor// Which is no longer valid. Note that a PL/SQL cursor loop// Implicitly does fetches, and thus may

A bare device, also called a raw partition, is a special character device that is not formatted and read by unix through a file system. It is read and written by the application. Buffer through the file system. Because the bare device does not pass

Prerequisites: we should make a statement in advance to ensure security. You cannot remotely log on to the initialized MySQL instance. To achieve logon, we strongly recommend that you create a user with a lower permission to log on remotely. Direct

10.2.0.5 on windows 64 bit Phenomenon: Copy backupset from server A to server B. Recover from server B. First, use 'catalog start with' to catalog backupset. When restoring the database, the following error occurs: RMAN> restore database

[Problem description] What do I do when a user prompts an error ORA-28002 that the password is about to expire? CIE68 :~ # Su-OracleOracle @ CIE68: ~> System/Atae1234 SQL * Plus: Release 11.1.0.6.0-Production on Tue Jan 19 15:15:50 2010 Copyright (c)

1. Clone Oracle with the same name-create a new PROD1 database on the 131 server and migrate it to the 137 server. The database name is still PROD1.1.1 dbca-131 PROD1Sys/oracleSystem/oracleUncheck all componentsNo EMNo FlashbackNo ArchivingORA-00845-

Use expdp When the EXPDP tool is used, its dump file can only be stored in the OS directory corresponding to the DIRECTORY object, rather than directly specifying the OS DIRECTORY where the dump file is located. Therefore, when using the EXPDP tool,

Environment: Win7_x64, Oracle 11g Description: The connection fails on the first day of the first day; 2: pl SQL developer Connection Tool, self-installed oracle database, and installed Client 3: oracle clients are not required when oracle is

Prepare an SQL script demo. SQL Set serveroutput onDeclareV_name dept. dname % type;BeginSelect dname into v_name from dept where deptno = & 1;Dbms_output.put_line ('department name is: '| v_name );End;/Exit; Then run the following command on the

There are two tables t1 and t2 Table t1 is structured Id, name, age Table t2 is structured Id The join statement is select t1. * from t1, t2 where t1.id = t2.id; We now need to retrieve the data after the association query. We recommend that

Each Oracle version has many new features and technologies. These technical features can greatly improve Oracle operation efficiency and application performance, or improve our daily work capabilities. Temp tablespace is a special tablespace object

Oracle SQL Developer displays the icon on Ubuntu and double-click it to run Terminal Access/usr/share/applications,Create the gedit SqlDeveloper. desktop file.Add the following content: [Desktop Entry]Name = SQLDeveloperComment = SQLDeveloperExec =

When we use catalog instead of controlfile as rman repository, the metadata information about the backup will also be stored in controlfil, so that when we use rman, you can use the information in controlfile even if the catalog is temporarily

Oracle is now evolving towards intelligence. If we are looking for Oracle books in the 8i/9i era, it is very important to configure appropriate database memory pools. However, after entering 10 Gb, automatic memory pool adjustment becomes an

MySQL multi-row insert Because mysql autocommit is enabled by default, and many production environments are set to write disks when the transaction is committed, the io overhead produced by the commit is very large. In a busy oltp system, this may