0X01 test Environment
Operating system: Window Server 2008 x64 oracle:oracle 11.2.0.1.0
0x02 Oracle Permissions Introduction
An Oracle instance is a database, and creating a new database produces a new instance, and an instance runs a process
Create an exp DMP file and use DD to destroy
The code is as follows
Copy Code
Sql> CREATE TABLE T_xifenfei as SELECT * from Dba_objects; Table created. Sql> Select COUNT (*) from T_xifenfei; COUNT (*)----------90915
Oracle Logminer is a practical and useful analysis tool that Oracle offers from 8i onwards, which makes it easy to get specific content in Oracle's online/archived log files, especially if the tool can parse all DML and DDL statements for database
1. Set back to delete before entering SqlplusBefore entering Sqlplus, execute the following command at the current terminal: Stty erase ' ^h '.Stty: Modify the terminal parameters. If you do not want to enter the terminal every time this command, in
Oracle is a broad and profound technology. After 2 years of playing Oracle, there are still a lot of knowledge points unclear. Yesterday the group of Friends mentioned the dedicated and SHARE two modes. Not clear, silently do some homework. From the
http://www.cnblogs.com/lzsu1989/archive/2012/10/17/2728528.htmlOracle EBS provides various forms of development and output of reports, and because of the obvious advantages of MS excel in processing data, report output is a common development item
First, the Oracle database installed on the computer, the installation of Oracle database in common sense, the direct download of the installation is OK, but midway is a problem, because my system is Win7 the client clients of Oracle does not
A very nice ebook on building reports in Oracle Fusion middleware 11g. This manual was intended for anyone the uses Oracle Reports to build Reports. The needs of both novice and advanced users is addressed. Following the step-by-step instructions,
Download the 3 required packages (in order to connect the 11g database)1:oracle Client (Oracle clients)Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/112010-win64soft-086667-zhs.htmlDownload Win64_11gr2_client.zip
Oracle Video Tutorial Goals Oracle Video tutorial, wind Brother this set of Oracle Tutorial Training learning Oracle parameter parameter file and Oracle control file Controlfile in depth, how to modify the parameter file, the role of Oracle
Methods for Oracle Connection stringsMethod One: Wmsys.wm_concat (column)Description: Its function was introduced in Oracle 10g, in the 10g version, the string type is returned, and the CLOB type is returned in the 11g version. The arguments inside
Summary of Oracle Performance Tuning recommendationsPrinciple One: Note the connection order in the WHERE clause:Oracle uses a bottom-up sequential parsing where clause, according to which the connection between tables must be written before other
Microsoft Windows [version 6.1.7601]Copyright (c) Microsoft Corporation. All rights reserved.C:\users\administrator>C:\users\administrator>sqlplus/as Sysdba;Sql*plus:release 11.2.0.1.0 Production on Wednesday October 29 09:50:55 2014Copyright (c) 198
Synchronize the original text to http://www.waylau.com/about-oracle-vm-virtualbox/ VirtualBox is an open-source virtual machine software. VirtualBox was developed by the German Innotek company, software produced by Sun Microsystems, which was
One, install the Ubuntu 13.04 Server 64-bit version (the simplest to install), and then install all the following accessories #apt-get update #apt-get Dist-upgrade # Apt-get Install Automake autotools-dev binutils bzip2 doxygen elfutils expat
SQL Server Migration Assistant for Oracle sample (2012-03-12 16:23:24) reproduced
Tags:ssmaoraclesqlserverit
Category: System
Introduction:Attempt to migrate Oracle 10GR2 data to SQL Server 2005 (or later).Things
Use a. NET application to connect to the Oracle database. netoracle
Recently, I was asked by my friends, "Why is there always an error in connecting the. NET application to the Oracle database ?", I think this is because we usually use Microsoft
Solution to Oracle 11g installation in Windows 7, oracle11g
Many DBAs are still in Oracle 9i or 10g, probably because of the price of Oracle 11g. This article will explain how to install Oracle 11g in Windows 7, and hope you can see some new
Oracle BASICS (4) pl/SQL
PL/SQL is also a program Language called Procedural Language/SQL ). PL/SQL is an extension of SQL statements in Oracle databases. The features of the programming language are added to the use of common SQL statements.
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service