Oracle

Before the project time to download an open source program, the database in the migration through the Exp/imp import and export, the results of the program in the start times wrong, after comparison found two database table more than 10, and then

To view the relationship between a user and a default table spaceSelect Username,default_tablespace from Dba_users;--View the tables that the current user can accessSELECT * from User_tables;--oracle Querying user tablesSELECT * from User_all_tables;

Project is urgent, need to deliver results in a short time, new team members, the database design is too low, it is difficult to understand the relationship between the database table structure, in order to enable new colleagues to better understand

Environment:mssql:2008ORACLE db:10.2.0.1no previous contact with MSSQL, recently due to the need for MSSQL access to the table in Oracle, the following is the configuration of the MSSQL connection Oracle.1. Install the Oracle client on the MSSQL

This article transferred from: http://www.cnblogs.com/iampkm/archive/2013/06/09/3128273.htmlUse the features provided by PL SQL to restore Oracle data quickly and back up.1 Export all user objects such as stored procedures, triggers, sequences, and

Dbms_random is a package that can generate random numbers or strings.This package has several functions such as initialize (), seed (), terminate (), value (), Normal (), random (), string (), but value () is the most common, followed by the

The character set consists of the following four types:1. Oracle Service-side character setSelect * from Nls_database_parameters;2. Oracle Server Registration Character SetHkey_local_machine/software/oracle/key_oradb11g_home1Nls_lang for character

1. Audit (Audit): The tracking records of the database activities performed by the user are easy to supervise and inspect afterwards.Audit Information storage location:Audit record information that is stored in the SYS in the system table space .

The architecture of an Oracle database consists of four aspects: the physical structure, logical structure, memory structure, and process of a database. 　　 1. Physical Structure 　　 The physical database structure is determined by the operating

Some of the company's Oracle projects have recently been transferred to Ms_sql and have encountered translation problems in translating Oracle functions into Ms-sql procedure.Luo lists these questions:First, Oracle basic type

Due to the expansion of the business and the requirements of the customer, the company needs to migrate the data originally running on MySQL to Oracle.The first few years of work have been short-lived, but infrequently used, and the initial

First, the purpose:Profiles in an Oracle system can be used to limit the database resources that a user can use, creating a profile using the Create Profiles command, It is used to implement restricted use of database resources, and if the

Recently, the company is doing Oracle database related products, here to summarize:ISNULL () functionGrammarISNULL (Check_expression, Replacement_value)ParametersCheck_expressionAn expression that will be checked for null. Check_expression can be of

Attention:That Oci.dll file is not installed Oracle inside to be downloaded separately that compression package extracted inside theWhich D:\instantclient_11_1\oci.dll in the decompressionInstantclient-basic-win32-11.1.0.6.0.zip Compressed Package

Installing 32-bit and 64-bit Oracle clients first in many Oracle installation introductions, there are references to setting 2 points, one, E1, and environment variables. nls_lang=simplified Chinese_china.

To add a column:ALTER TABLE TableName add ColumnName datatype (not NULL); -------One thing to note is that when adding a column that is not empty, the table must be an empty table.To delete a column:ALTER TABLE tablename DROP column ColumnNameTo

1. Installing Logminer Run the following 2 scripts as DBA users: Dbmslm.sql is used to create a DBMS_LOGMNR package to parse the log file. sql> @ $ORACLE _home/rdbms/admin/dbmslm.sql; Package created.

In Oracle, the Utl_file package provides a number of functions and procedures for manipulating text files, learning about his basic operations 1. Create a directory and give the user authorization to copy the Code code as follows:--Creating

Comparison of deleted data DELETE statements and TRUNCATE statements for Oracle databaseWhen the data in the table is not needed, you should delete the data and free up the occupied space, and delete the data in the table using the DELETE statement

--Create UserCreate user Han identified by Han default tablespaceUsers temporary tablespace Temp;Grant Connect,resource,dba to Han; Grant users the right to Han developers--------------------the operation of the