Oracle

Starting from 10 Gb, oracle began to provide Shrink commands. If our tablespace supports automatic segment space management (ASSM), we can use this feature to narrow down the segment, that is, reduce the HWM. Here we need to emphasize that this new 1

Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local dmp file, and the imp command can import the dmp file from the local to

1. Preparation Process   1.1 check and set database roles First, check whether there are CTXSYS users and CTXAPP roles in the database. If you do not have this user or role, it means that the intermedia function is not installed when your database

Oracle used raw via lvm to handle raw usage issues for a production database of another company in the morning. On-site staff said they would use the new lvm space for oracle, and lv had already been made, the ing is also bound, but raw is not

11gR2 Grid Infrastructure Installation prerequisites On LINUX Basic Environment server brand IBM server model X3650M2cpu type Intel Xeon E5620 @ 2.40GHzcpu Number 2 memory size 24g disk array DS3200 hard disk size 1.8 TB software preparation: --

In Oracle, The TO_DATE format and other date functions are in the TO_DATE format (take the time: 13:45:25 as an example) Year: yy two digits two-Year display value: 07 yyy three digits three-Year display value: 007 yyyy four digits four-digit year

Oracle 10g installation in win7, select advanced options, prompt program abnormal termination, unknown error solution oracle 10g installation in win7, select advanced options, prompt program abnormal termination, if an unknown error occurs, modify

To Merge multiple rows into one project, you must merge multiple rows into one project. The table structure is as follows: NAME Null Type ----------------------- ----- N_SEC_CODE not null char (6) C_RESEARCHER_CODE not null VARCHAR2 (20) This table

About ORA-01187: cannot read from file because it failed verification tests Handling Environment: OEL + Oracle 11.2.0.3 + physical standby Problem description: Ora-01187 error code displayed when querying dba_temp_files attempts; ORA-01187: cannot

Oracle Data Guard role conversion experiment environment: OEL + Oracle11.2.0.3 + physical standby as we all know, Data Guard is already the mainstream disaster tolerance solution of today's standards. Due to the strong adaptability of log

Oracle lists all the table names. The column name takes one day. there may be better methods. test environment: oracle xe 11g 1 shows all table names: select table_name from user_tables; 2 shows all column names: select OWNER, TABLE_NAME,

[Oracle] methods for obtaining execution plans 1. estimate execution Plan-Explain plan Explain Plan uses an SQL statement as the input to obtain the execution plan of this SQL statement and store the execution Plan output to the schedule. First, add

The GoldenGate Data Pump Process report the WARNING OGG-01223 Cannot find executable file '. /Server' cannot be started to solve a strange problem today. The na server's buddy called to say that our data pump process was not started, and the data

Oralce 10g officially certified Operating system version oralce 10g officially certified Operating system version Operating system x86 Red Hat Enterprise Linux AS/ES 3 (Update 4 or later) red Hat Enterprise Linux AS/ES 4 (Update 1 or later) Oracle

Manual Oracle Uninstall manually Uninstall oracleA number of people have contacted me regarding problems uninstalling Oracle products. the two methods listed below shocould only be used as a last resort and will remove * all * Oracle software

Oracle 11g remote export database 1. Create a TNS string: zqxt = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 132.97.172.186)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ora11g) ))  2. query the

Oracle 11g RAC executes root. sh encountered CRS-0184/PRCR-1070 problems Oracle 11g RAC installation, at the first node execute root. sh encountered a CRS-0184/PRCR-1070, Google a lot of posts have not found a solution. Hey, let's calm down and look

Oracle Patch Bundle Update I. Introduction to related knowledge I only know CPU (Critical Patch Update) and PSU (Patch Set Update), but I do not know that there is a Bundle Patch, due to a TNS-12531 BUG, you need to install at least Patch bundle 22

Use PLSQL Developer to remotely log on to oracle, and web management to log on to PLSQL Developer only after installation, you can access the local oracle, but there are some problems in accessing the remote server oracle or the oracle of the

Oracle-full recovery of User Management (1) I. categories can be divided into full recovery in non-archive mode and archive mode. full recovery is mainly for archive mode, and it is difficult to achieve full recovery in non-archive mode, unless