Oracle

Create directory gives us the flexibility to read and write files in an Oracle database, greatly improving the ease of use and scalability of Oracle.Its syntax is:CREATE [OR REPLACE] Directory directory as 'pathname';This case is specifically

Brief analysis of packagePackages in Oracle Brief analysis of the basic concept of a packagePackages can organize several functions or stored procedures to be stored as an object. The package is usually composed of two parts, specification

/** Create tablespace (as System identity)*/CREATE tablespace spc_myself--Table space Name (spc_myself)DataFile ' E:\datafiles\MYSELF. DBF '--datafile specifies one or more data files for the tablespace, ' path and name of the data file 'Size

Oracle TIP error message ora-28001:the password has expiredLog in with Sqlplus/as SYSDBA on the Oracle server to view the account status using the following SQL statement:Select from Dba_users;Find the corresponding user name, if the status is

Oracle table names, field names are case-insensitive, Sybase is strictly differentiated2.Oracle To_char ()/to_date ()---sybase convert ()--oracle:to_char (sysdate, ' dd-mm-yyyy Day '), To_date (String,format)--sybase:convert (char (15), date, 108),

Recently learning Oracle database, made some structure diagram convenient memory! The main concerns are Oracle data types, Oracle's table operations and Oracle cursors, and others to share ...Oracle Data typesBecause the picture can only see the

Oracle ora-01033:oracle initialization or shutdown in progress error resolution"ORA-01033" error when logging into databaseIn the command window, log in as sqlplus as sysdba--note that the value after the sqlnet.authentication_services parameter in

a) Date function [focus on the first four date functions]1.add_months[return date plus (minus) The date after the specified month (before)Add_months (D1,N1)"Function": Returns the new date after the date D1, plus N1 months."Parameters": D1, Date

The database resource Manager controls the distribution of resources across sessions by controlling execution schedules within the database. By controlling which sessions to run and the length of time that the session runs, Database Explorer ensures

Principle of monitoring service and access connectionPort number range: 1025~6500[[email protected] ~]$ Lsnrctl--access to the Monitoring management toolLsnrctl for linux:version 10.2.0.1.0-production on 05-jun-2014 11:13:20Copyright (c) 1991, 2005,

Ii. Oracle's parameter file management1. Introduction of parameter FilesTwo types of parameter files:(1) spfile parameter file (binary file)(2) pfile parameter file (text file)Path to the parameter file store: $ORACLE _home/dbs[email protected] dbs]$

2. Modifying parametersParameters inside the SPFile and pfile files:orcl.__db_cache_size=373293056orcl.__java_pool_size=33554432orcl.__large_pool_size=4194304orcl.__shared_pool_size=192937984Orcl.__streams_pool_size=0*.audit_file_dest=

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright. Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/43971547Lab

How to read Oracle's execution planFirst, what is the implementation planAn explain plan is a representation of the access path, that's taken when a query is executed within Oracle.Second, how to access dataAt the physical level Oracle reads blocks

A character set error was found after installing Oracle, so you need to modify the character set as follows:System Environment: CentOS 6.5Oracle Version: 10.21. Log in to the system and switch to Oracle user rights # su-oracle2. Then enter:$ sqlplus/

Use of Oracleasmkfed Tool [root@localhost db_1]# su - oracle[oracle@localhost ~]$ cd /u01/app/oracle/product/10.2.0/db_1/rdbms/lib[oracle@localhost lib]$ pwd/u01/app/oracle/product/10.2.0/db_1/rdbms/lib[oracle@localhost lib]$ ls -lrt ikfedls: ikfed:

Windows dbca encountered an error when deleting OracleserviceXXX: dim-00014CannotopentheWindowsNTServiceControlManager When dbca deletes OracleserviceXXX in windows, the following Error occurs: dim-00014 Cannot open the Windows NT Service Control

How to modify the location of Oracle Database Data Files A data file is a file ending with dbf, that is, a file used to store our data. This file is usually large, so we generally store it in a directory with a large space, let's take a look at how

Oracle3 SQL statistical scenariosWhen using oracle for statistics, we often encounter the following scenarios:1. Convert vertical columns to horizontal Columns2. Group and merge a column as the result set3. Obtain the first record for grouping and

Auto increment of ID fields in the SQL _Oracle table Objective: To automatically increment the ID field when inserting data into a table. Start the experiment: (1) Create an experiment table Createtable test_ID_add ( Id number (10 ), USERNAME