Oracle

In Oracle, the default listener port number is 1521, once someone scans the port number will know that this server is an Oracle database server, there is a great security risk, here, teach you how to modify the Oracle default port number is 9999:1.

1, separate download instantclient_10_2, in the cloud disk has2. Preference configuration path in Plsql3, E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN in the Listener.ora# Listener.ora Network Configuration

1, get the last day of the monthSELECT To_char (Last_day (to_date (' 20140125 ', ' YYYYMMDD ')), ' YYYYMMDD ') Lastday from DUAL2, get the last day of the end of last month:Select To_char (Add_months (Last_day (' 2008-08-08 ', ' yyyy-mm-dd '), -1),

First, background:The specific scenario is that the database is not an ordinary OLTP system, more like an OLAP system, the data update frequency is very low, operating in the Noarchivelog mode, real-time requirements are low, but only one copy of

#coding:gb18030 import cx_Oracle import xlsxwriter import time import sys reload(sys) sys.setdefaultencoding("gb18030") con = cx_Oracle.connect("user/[email protected]") cursor = con.cursor() query1 = cursor

@echo off Echo ================================================ Echo automatic backup script for Oracle database in Windows echo 1. Use the current date to name the backup file. Echo 2. Automatically delete backups up to 30 days ago. echo ===========

One, the Oracle data dictionary is composed of the following views mainly:1.user ViewUse User_ as a prefix to record information about user objects2.all ViewAll_, which is used to record the information of the user object and the object information

Control file is one of Oracle's physical files that records information such as the name of the database, the location of the data file, and so on. The importance of the control file is that once the control file is corrupted, the database will be

Oracle SQLLDR Use (fast import, but weak handling of the data itself)Blog Category: Db. Oracle Oraclesql Sqlload.cmdSQL code Pause Sqlldr user/[email protected] control.ctl skip=1 rows=2000 bindsize=8192000 Pause

Recently found in Javaeye many comrades on the optimization of SQL seems to know very little, recently summed up a few for reference only, but a few may depend on the situation, most of it is quite effective.Note: The following (inefficient) and

After Oracle installation is complete under Linux, the database command DBCA cannot be used.Workaround:In a 32-bit LINUX environment, the installation of 32-bit oracle11g will have this bug, the main patch (patch name:p8670579_112010_linux.zip) can

Exp Dadifilm/[email protected] file=/tmp/dadi.dmp full=yImp U_data/[email protected] File=/dadi_desc.dmpImport:release 11.2.0.1.0-production on Tue Feb 3 18:42:12 2015Copyright (c) 1982, the Oracle and/or its affiliates. All rights

Check the first 10 data in the table in Oracle----SELECT * FROM test where rownum SELECT * FROM (select A.*,rownum rn from Test a) where RN >=10 and rn= method of comparison.For practical purposes, the most recent data is often returned, and the

At the beginning of Oracle, a lot of unfamiliar, built the library, no users, and did not create table space, directly system users to build a table to add data, a few months past, the table built nearly hundred, the data added tens of thousands of,

Calling the Oracle stored procedure in javaCalling the Oracle stored procedure in java This article describes how to call the stored procedure of Oracle through java.1. Write the Stored Procedure Create or replace procedure sp_pro3 (sp_name VARCHAR2,

Oraclesql tuning set **************************************** * ******************** 1. create an optimization set object ************************************ * ********************** --- authorize grant administer any SQL TUNING SET to scott; ---

ORA-14402: updating partition keyword columns will cause partition changes, ora-14402 keywords By default, oracle Partition Table for partition fields is not allowed to update the operation, if there is a forward update on the partition field, the

Using the DBMS_CRYPTO package in oracle to encrypt sensitive fields in the table Next, let's take a look at how to encrypt table sensitive fields through the DBMS_CRYPTO package in oracle. If you need to know, let's take a look.   As security is

How to import additional fields in Oracle as null values Q: We have migrated our Oracle database to a new environment. Some customer tables exist in two databases at the same time, but those tables in the new environment have some additional fields.

Introduction to OSFA and data warehouse in Oracle Oracle Financial Services Application (OFSA) technical platform: includes Oracle Warehouse Builder Data Warehouse building tool, Oracle8i Database, Oracle Express multi-dimensional database, Common