Oracle database objects and user management
www.ncn.cnThe management and maintenance of the pattern object of Oracle DatabaseThis section focuses on the management and maintenance of schema objects for Oracle databases, which include table spaces, tables, views, indexes, sequences, synonyms, aggregates, and
1. Install the operating system Oracle Enterprise Linux 5.2
2. Create a user
Create an oracle user, create a dba group and an oinstall Group[Root @ oel_11g ~] # Groupadd oinstall[Root @ oel_11g ~] # Groupadd dbaThen, create a directory/u01/app/oracle under the root directory. We plan to install the Oracle11G software in the/u01/app/
Oracle Database Operations (10)-logical backup and recovery of databases (tables), oracle backup and recovery
Logical backup and recovery of databases (tables)-export
System can export any scheme, for example:
Exp system/manager @ myoral owner (system, scott) file = d: system. dmp; // Note: two schemes can be exported: system scheme and Scott scheme.
Exp system/
* Plus window, you must close it before setting the environment variable nls_lang.
2) switch to the path E:/apex_4.0.2/apex/Builder/ZH-CN, start SQL * Plus, and run the following statements as sysdba:
SQL>ALTER SESSION SET CURRENT_SCHEMA = APEX_040000;SQL>@load_zh-cn.sql
After the installation is complete, go to http: // 127.0.0.1: 8080/apex/apex_admin to switch the language between "English" and "Chinese (simplified)" at the bottom of the interface.
Additional supplement:
Solve the problem tha
Generally speaking, we do this through ODBC to access the remote backend database. However, ODBC has a fatal drawback--slow speed. In fact, for Oracle databases, in addition to ODBC, we can use the OLE object (Oracle Objects for OLE) provided by Oracle itself to quickly access the
Summary of basic Oracle database knowledge (1): Basic oracle knowledge
Database Name, Instance name, database domain name, global database name, and service name are several confusing concepts for many beginners. I believe that ma
The premise is that the firewall on the server has been disabled or port 1521 has been replaced.To connect to the oracle server on a machine without an oracle Server, first install the oracle client.I am now installing an oracle lite client. After installation, open PLSQL Developer. You will be prompted to enter the us
Today, we will paste an Oracle database backup feature that has been implemented very early. This feature was designed at the university stage:
Today, we will paste an Oracle database backup feature that has been implemented very early. This feature was designed at the university stage:
Today, we will paste an
Followed by the above article: http://ixdba.blog.51cto.com/2895551/880511
14. Install Oracle Clusterware
1) decompress the Software PackageAssume that all the database software is in the/rac directory. First, extract the two Oracle software packages as follows:[Root @ node-rac1 rac] # lsLinux_11gR1_database_1013.zip linux_x86_11gR1_clusterware.zip[Root @ node-rac
Label:The navicat is connected to an Oracle server through an Oracle client. There are two types of clients for Oracle, a standard client setup program:Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlThe other is a "concise version" of the client, called
[01] Oracle Database introduction, 01oracle database Introduction
Oracle relational database: built on the relational model.
Oracle10g: g (grid) Grid technology. grid Computing connects a large number of computers through network sharing and integrates the redundant processi
There are netizens on QQ to find me, said Oracle 7.3 database, because redo abnormal consultation I can restore
Check the database for the following information
The code is as follows
Copy Code
Svrmgr> select * from V$version;BANNER----------------------------------------------------------------Oracle7 Workgroup Server Relea
Label:Oracle Learning Starter Series IV Introduction to Oracle Database Finally the smooth transition to Oracle, we in the first article in the Black Larry once, here will need to wash the white. Saying that when Qian Zhongshu wrote "Fortress besieged" after, inadvertently said, an egg even if delicious, there is no need to know which hen lays eggs. Toad felt a l
Recently developed C ++/OracleProgramI have not performed any project related to c ++ operations on Oracle. I checked the materials and found the OCI, which is really good.
Oracle call interface (OCI) is the most comprehensive and performance-oriented Oracle Database Interface Based on the native "C" language. It pro
Tags: represent field one type pen PIL ESC index HardwareDatabase In-memory is one of a number of options the can deployed to address Oracle e-business Suite performance conce RNs and scalability requirements without the need for any application changes. We is pleased to announce the publication of a new white paper so can help with this (including links to patches that Y ou'll need to apply):
Using Orac
Differences between Oracle database and MySQL database:
1. Group function usage rules
In MySQL, group functions can be used at will in select statements. However, if a group function exists in a query statement in Oracle, other column names must have been processed by group functions, or a column in the group by claus
)BITMAP Each bit corresponds to a rowid, its value is 1 or 0, if it is 1, indicating that the bit corresponding to the ROWID has a value;===========================================================There are several ways to find data in Oracle, to understand how to find data, to help us read the execution plan, and to optimize our Oracle database system by executin
A very standard sample code for connecting Java to the Oracle database, oracle sample code
The most basic Oracle database connection code (only for Oracle11g ):
1. Right-click Project-> build path-> Configure build path, select the third item "library", click "add external J
Tags: Oracle training Oracle Database tutorial Oracle Video Oracle Tutorial Oracle Video TutorialOracle Video Tutorial GoalsOracle Video tutorial, wind Brother this set of Oracle Tutori
at the end of 2013, it further expands the comprehensive portfolio of Oracle products in application, social networking, platform and infrastructure services. At the same time, Oracle recently released a series of cloud-oriented Database and software integration products, including Oracle
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.