Oracle

OracleTo solve the problem, follow these steps: At the beginning, I planned to shrink the data file in the temporary tablespace. Run: SQL> alter database tempfile 2'/oracle/oms/oradata/temp/temp01.dbf' resize 10240 M; The database reports an

InOracle DatabaseDuring the operation, we may encounter this situation, and the data in the table may be repeated, which makes it inconvenient for us to operate the Oracle database, so how can we delete the useless data? The deduplication technology

Database SecurityIt has always been a hot topic of interest. As we all know,Oracle DatabaseThe data information in the Oracle database is very important and should not be disclosed. The following section summarizes some security measures for the

Processing of time in Oracle Database: 4824 hours for HH24 Select to_char (sysdate, 'yyyy-MM-dd HH24: mi: ss') from dual; Select to_date ('1970-01-01 13:14:20 ', 'yyyy-MM-dd HH24: mi: ss') from dual; To_date () function 1. Description of date format

Next we will introduce the usageSQL DeveloperBuilt-inOracle Migration WorkbenchThe migration process from the Microsoft SQL Server 2008 database to the Oracle 11G is recorded in the following five sections. Next we will introduce them separately.

This article introduces the fourth part:SQLToOracleThe processing of the name. By executing the data migration wizard, if there is no error, the table structure will basically be established, and the orcl (migrations) connection will be opened in

Oracle 10 Gb ConfigurationIncorrect error analysis and solutions are the main content we will introduce in this article. Let's get familiar with this part. The following problems occur when connecting to the database after Oracle 10 Gb is installed:

OracleDatabaseSqlload usageThe related knowledge is what we will introduce in this article. What is sqlload? After reading the example below, we will know. When using the Oracle database to process millions of data, it is better to choose sqlload.

Oracle server processIn the process of completing a user process request, the following seven tasks are completed: 0. SQL statement parsing; 1. the data block is read into the database buffer and written to the data cache); 2. logs; 3.Create

I often ask my friends how to become a master when learning oracle. I would like to give a few simple points based on my personal experience:1. lay a good foundation from a simple perspective Learning Oracle cannot rush to success, and hopes to

0. tablespaceSQL> select username, default_tablespace from user_users;View the role of the current userSQL> select * from user_role_privs;View the system and table-level permissions of the current userSQL> select * from user_sys_privs;SQL> select *

First, using sqlplus to manage databases is the highest level ~ It is also helpful for us to understand oracle. We should not rely too much on third-party development tools, such as plsqldeveloper. These tools are used for Development kits, stored

  1 Definition Audit_sys_operations audits SYSDBA activities. The default value is false. The related audit information is not recorded in aud $, because it is possible that the database has not been started yet and can only be recorded in files at

  ORACLE Database monitoring fails to report an error, which is quickly solved. Record the problems here for future reference. Should I enter the IP address or HOST name after the HOST in the listener. ora file of the database? Many may have

  -- Create a test table name Create table job_table (run_date date ); -- Create a stored procedure Create or replace procedure job_proc Begin Insert into job_table (run_date) values (sysdate ); End;   -- Create a job and run it once every

  Where can I start learning about Oracle? Here, I will take you to the door of Oracle. One chapter a day, seven days of entry is not a dream.   1. Development subroutine A subroutine is a named PL/SQL block. This block can contain parameters and

Character functions used by stored procedures to process strings -- return character values all functions receive family-type parameters (except for CHR) and return character values. except for some special descriptions, most of these functions

Use the lock_sga and pre_page_sga parameters to ensure that the SGA resident physical memory LOCK_SGA locks the entire SGA into physical memory. it is usually advisable to lockthe SGA into real (physical) memory, especially if the use of virtual

Hash join, nested loop, and sort merge join have three table join modes in the oracle execution plan: hash join and nested loop, sort merge join1, hash joinhash joinA join in which the database uses the smaller of two tables or data sources to build

After Oracle Database (10.0.2) is installed to solve the problem of changing the computer name Oracle cannot be started, if the machine name is changed, the OracleTNSLisener service in the control panel will be stopped immediately. With the command