oracle data quality for data integrator

Management of 1.Oracle Tables Naming conventions for table and column names: Must start with a letter; Length cannot exceed 30 characters; Cannot use Oracle's reserved words; Use only the following characters: A-Z, A-Z, 0-9, $, # etc. Data types supported by Oracle: Character type Char fixed length maximum of 2000 charactersc

Method One: Use the Pl/sql Developer tool to export:Menu bar---->tools---->export Tables, the following figure, set the relevant parameters can be: Method Two: Use CMD's Operation command to export, the details are as follows:The 1:g:\oracle\product\10.1.0\client_1\network\admin directory has a Tnsname.ora file that reads as follows: Copy Code code as follows: Cmstar = (DESCRIPTION = (Address_list = (address = (PROTOCOL = TCP) (H

Document directory 2. 1. Export data from the table to a file (using trusted connections) 2. export data from the table to a file (using Hybrid Authentication) 2. 3. Import the data in the file to the table 0. References: SQL Server BCP usage Summary BCP Utility How to import data from 6 million users to MySQL, MS

Oracle Data Processing and oracle Big Data ProcessingDML Language : address character; (PrepareStament) Batch Processing: insert -------- insert employees of Department 10 to a new table at a time; Do not write values statements; the Value List in the subquery should correspond to the column name in the insert substate

Sort out the key points of Data Query Optimization in Oracle databases, and query oracle Data The most basic task of a database is to store and manage data. The only database feature that an end user can see is its performance: the speed at which the database processes the r

Summary of oracle accidental deletion data recovery methods and oracle accidental deletion data recovery If the user accidentally deletes/updates the data, there is no direct way for the user to recover the data, they must seek he

Microsoft Windows [version 6.1.7601] Copyright (c) Microsoft Corporation. All rights reserved. C:\users\ckz>sqlplus ZZJD/[EMAILNBSP;PROTECTED]/ORCL as SYSDBA; Sql*plus:release 11.2.0.1.0 Production on Wednesday May 17:00:46 2015Copyright (c) 1982, Oracle. All rights reserved. Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-productionwith The partitioning, OLAP,

Tags: Oracle data access other Oracle dataCreate a database link on your local Oracle databasesDROP DATABASE LINK Mydblink;Create DATABASE link Mydblink connect to zszq identified by "zszq" using ' 192.168.0.175:1521/ORCL '; sql> DROP DATABASE LINK mydblink; The database link has been deleted. Sql> CREATE DATABASE link

following method to implement the original statement: Select/* +Rule*/Y. deptno, Y. ename, Y. empno, Y. Job, X. sal_tot, X. comm_tot From (select empno, sum (sal_amt) sal_tot, sum (Comm) comm_tot From salary s Where S. deptno in (select deptno from employee like '2013 ') And S. sal_date between '20160301' and '20160301' Group by empno) x, employee y Where Y. empno = x. empno; Run the rule prompt to execute the SQL statement according to the index rules. First, run select deptno from employee li

First use is using: SYSDBA login Sqlplus/as SYSDBAIn the SQL command line, enter ALTER DATABASE open;This time it will be reported similar to "ORA-01157: Cannot identify/Lock data file 12-see DBWR trace file ORA-01110: Data file: ' E:\DBF\A.DBF '" error.This is because the a.dbf file was physically deleted, but the associated record was not deleted in the Oracle

Oracle Database for the Data Type of database fields, oracle Data TypeModify the Data Type of Oracle Data Columns Method 1: // Create the same temporary table Create table T_BUSINESS_M

Oracle basic (7) data table, oracle basic data table 1. Create a table Syntax: Create table [schema.] table (Column datatype [, column datatype [,...]); Note: Create table: the keyword used to CREATE a TABLE. Schema: indicates the owner of the object, that is, the name of the schema. If you create a table in your schem

ORACLE converts data between milliseconds and dates, and oracle converts data between milliseconds. Convert millisecond to date SELECT TO_CHAR(1406538765000 / (1000 * 60 * 60 * 24) + TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') AS CDATE FROM DUAL; Date conversi

Oracle triggers. When a table is updated or inserted, data is synchronized to a table in another database. oracle Data is synchronized. Two tables are the T_SRC_WEATHER_TSPG fields under User, User B's t_src_weather table, It is required that when the T_SRC_WEATHER_TSPG table under user A is inserted or updated, the

Oracle quick export of data files, oracle export of data There are many data file generation methods, but most of them are inefficient. For large data warehouses, efficient file export is an urgent requirement: Here, the shell + j

Label:Extract the contents of the tables and LOB fields in the database files in the damaged disk by using the Oracle Dul tool In a 8i library recovery, as hard disk damage caused a number of tables to have a lot of paradoxical bad blocks, trying to use Dul to mine data, when using Dul 9 encountered a problem: when a table has a lob type, but also has a varchar2 type, and VARCHAR2 type

Oracle clears all table data and oracle clears table data Method: 1. Delete all foreign key constraints 2. drop table 3. Add foreign key constraintsCode generated using powerdesign /*==============================================================*/ /* DBMS name: ORACLE Vers

Oracle Database-related data dictionary for performance problem analysis, oracle-related data The nine most important dynamic performance views of oracle! V $ session + v $ session_wait V $ process V $ SQL V $ sqltext V $ bh (prefer x $ bh) V $ lock V $ latch_childr

How Does Oracle query duplicate data ?, Oracle duplicate data? -Query duplicate data Select tt. * from Table tt where custom conditions and tt. repeated field in (select t. repeated field from table t where custom condition group by t. repeated field having count (t. repe

Oracle Data Import/Export, oracle Data Import and Export Import and Export Oracle Data imp/expFunction: Oracle Data Import/Export imp/exp is