Oracle

  1. View tablespaces Select tablespace_name, file_name from dba_data_files; 2. Create a statspack tablespace Create tablespace perfstat datafile 'd: \ oracle \ oradata \ perfstat. dbf' size 500 m The tablespace should be as big as possible. 3.

  1. Preparation Our first step is preparing the box for our test replication. I am using a VMWare virtual server for my tests. Install linux x64 on your box. I used Linux Centos 5.3. The hostname for our source box will be db1. Install the Oracle

  In the database design, Oracle databases pioneered the design concept of tablespace, which makes an indelible contribution to the high performance of Oracle databases. Basically, many optimizations in Oracle databases are implemented based on the

This section describes common Oracle Database Constraint restrictions and Exception Handling. Next, let's take a look at this part.1. Report constraints exceptionIf an exception exists during validation constraints, an error is returned and the

What should I do if there are unnecessary services in oracle service items? The following describes how to delete a service that is not used in oracle service items. We hope this will help you learn about oracle service items. Management -->

Oracle has completed its acquisition of SUN and released an integrated plan for Sun's businesses in January 27. In general, Oracle should become the vendor of integrated software and hardware solutions. The following describes the Java-related

Today, I encountered A problem. In database A and database B, the table structure is the same. to export some records to table A of database B,The problem is that two identical tables in the two databases contain BLOB and CLOB fields. After thinking

1. First define a method to return the array typeCreate or replace type my_table_type is table of varchar2 (20 ); Create or replace function funcReturn my_table_typeIsI my_table_type: = my_table_type ();BeginSelect name bulk collect into I from emps;

The Bulk Collect feature is introduced in Oracle8i for the first time. This feature allows you to use batch queries in PL/SQL. Batch queries can significantly improve query efficiency in some cases. Now, we will perform some simple tests and

1. exp/imp is equivalent to restoration and backup of the oracle database.2. exp exports data to the local dmp file, and imp imports the local file into the database3. exp/impcan be executed in cmd.exeI. Data export:1. Export the database EDWTEST

Solution: Open the oracle folder and search for the file "emd. properties". Right-click to open it in notepad. Remember: the path must be: E: \ oracle \ luo-PC_orcl \ sysman \ config \ emd. properties, rather than the directory E: \ oracle \ sysman

An error is reported when deleting a temporary table in plsql:  Summary:Oracle's temporary table design principle is that temporary tables are bound with sessions. the data in the table and related things are bound to the same session. The data

How to Improve SQL Execution efficiency in Oracle --> when the FROM clause contains multiple tables, select the table with the least number of records as the base table --> the WHERE clause is parsed to have a bottom-up filtering condition in order -

Data Tables move from one tablespace to another. Data Tables move from one tablespace to another. 1) alter table [table_name] move tablespace [new tablespace]; move the LOB Field 2) alter table [table_name] move lob ([lobsegment_name]) store as

Oracle Database Export and re-import 1. Export Database 1. Completely export the database TEST, username scott password tiger, and export it to D: \ testDB. in dmp: [plain] exp scott/tiger @ TEST file = d: \ testDB. dmp full = y 2. Export the table

How to determine whether a backup set can be recovered (Note) 1. Bad blocks (1. physical blocks (2. physical damage to logical blocks: In a physical BLOCK resume uption, which is also called a media uption, the database does not recognize the block

Change the data file path of the standby database to change the data file path of the standby database [oracle @ bldc02 ~] $ Sqlplus/nologSQL * Plus: Release 11.2.0.3.0 Production on Mon Aug 26 10:44:57 2013 Copyright (c) 1982,201 1, Oracle. all

Restore redo after oracle closes normally [Oracle @ oracle-one RHYS] $ ls-ltrtotal 4898536-rw-r -----. 1 oracle oinstall 52429312 Aug 27 redo02.log-rw-r -----. 1 oracle oinstall 52429312 Aug 27 redo01.log-rw-r -----. 1 oracle oinstall 5251072 Aug 27

[One Moss per day]-RAC and Sequences (853652.1) Sequences have four combinations:. CACHE + NOORDERb. CACHE + ORDERc. NOCACHE + NOORDERd. NOCACHE + ORDER even in a single-instance configuration, when a large number of sequence needs to be generated,

Analog ORA-01555 SQL> create undo tablespace undo_temp1 datafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ ordb10 \ undo_temp1.dbf 'size 2 M autoextend OFF; tablespace created. SQL> alter system set undo_tablespace = 'undo _ temp1' scope = both;