oracle odi

1. View all tablespaces: SELECT * from Dba_tablespaces;2. View the default tablespace for a user: SELECT default_tablespace,username from Dba_users WHERE username= ' USERNAME ';3. View the remaining capacity of the table space: SELECT tablespace_name,sum (BYTES) from Dba_free_space GROUP by Tablespace_name;4. View information for tablespace data files: SELECT * from Dba_data_files;5. Create TABLE space: Creation tablespace ODI datafile ' D:\

Oracle how to ensure the ACID principle of transactions -- oracle Core Technology Reading Note 2, acid -- oracle There are four general principles in the transaction that all databases must comply with, referred to as the ACID principle. The following briefly describes how oracle implements these four principles. 1. A

1.oracle InstallationRefer to http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html, no longer repeat here2. Command line sqlplus Connect Oracle(1) Check the monitoring statusc:\>lsnrctl StatusLsnrctl for 32-bit windows:version 9.2.0.1.0-production on 2 August-June-2005 11:01:01Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Connecting to (D

Tags: OracleSet power on (Linux) auto-start Oracle shutdown automatically shuts down Oracle1, switch to the root user, confirm that the startup file and the shutdown file is present[Email protected] bin]$ pwd/u01/oracle/product/10.2.0/db_1/bin[[email protected] bin]$ ls DbstartDbstart--sqlplus script to invoke when executing startup[[email protected] bin]$ ls DbshutDbshut--sqlplus the script to invoke when

Oracle redo complexity-oracle Core Technology Reading Note 3, redo-oracle I. Overview We know that in oracle, Every modification to a piece of data generates a redo (that is, redo, which records the modified content ). The purpose is to back up the modified data for future redo. Now there is a problem. Redo logs are ge

Because of the installation of Oracle 10G when there was a problem, and then asked roommates to send a copy of the Oralce 10g client installation package came up. It was possible to use Pl/sql, and then, in the case of a job need, to import an Oracle database backup from a colleague at a time, making IMP statement to import a 6550 error, the internet to check the reason is because the server and the clien

Some of the basics of Oracle have been learned some time ago, and for ease of practice and operation, an Oracle 10g was installed. After the installation, the book was directly discarded. Card to the death, card to directly can only be used as the Internet. At that time because of busy also do not do other things, so has not been in charge of it. Make up for the last Internet café. The two days are free. So

Tags: not primary users ODI list A code sample automatic conversion operationI. Preparation TOOLS1.Oracle database: Full name Oracle Datebase is a relational database management system of Oracle Corporation;2.pl/sql:pl/sql Developer is an integrated development environment specifically for the development of

First, create"Project" Designer-Projects, click the Insert item icon, In the Project dialog box, under the Definition tab, enter the project name, such as Odi_exercise, to save second, import knowledge module Project → knowledge module → Right-click import Knowledge Module File import Directory: Oracle\middleware\oracle_home\odi\sdk\xml-reference Reverse Engineering Knowledge Module (RKM)

1. Oracle Installation Please refer to the following link for more information: http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html. 2. Use the command line sqlplus to connect to Oracle (1) Check the listening status C: \> LSNRCTL status LSNRCTL for 32-bit windows: Version 9.2.0.1.0-production on 2005 11:01:01 Copyright (c) 1991,200 2, Oracle Corporation. A

It takes a day and a half to resolve the client connection to the Oracle database on the server side, unable to connect the problem. Ora-01034:oracle Not available (ORACLE does not exist), ora-27101:shared memory realm does not exist analysis:A few days ago you can also connect to the database, but yesterday, the local no reason to connect to the server database.

Oracle Server entry and oracle management routineI. Common oracle database management toolsOracle Universal Installer (OUI): used to install, upgrade, or delete Software ComponentsOracle Database Configuration Assistant (DBCA): a graphical user interface tool that interacts with OUI. It can also be used independently to create, delete, or modify databases.SQL * P

What is a relational database? Oracle database architecture, Oracle cluster introduction, and oracle Architecture What is a relational database? Databases based on Relational Models. What is a relational model? Use rows and columns in a two-dimensional table to maintain the data model. Oracle database architectur

Tags: style blog http ar file Data SP Div 2014  1 installation Knowledge of Oracle (oracle10g and oracle11g version differences ) :A the installation directory should not have Chinese and white spaceB oracle10g support winxp does not support win7,8 and vista;oracle11g supports all versions2 oralce Server: comprised of Oracle instances and Oracle datab

Some time ago I started to learn some basic knowledge about oracle. To facilitate exercises and operations, I installed an Oracle 10 Gb. After the installation is complete, the current database is directly deprecated. The card is terrible. The card can only be used for surfing the Internet. At that time, I was too busy to do anything else, so I never care about it. Together with the last Internet cafe. Thes

Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4 I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC environment of Oracle 11g R2 11.2.0.4. The operating system version is Oracle