First step: Connect the server, enter SqlplusStep Two: Login as SysdbaStep three: View and modify processes and sessions parameters1. View processes and Sessions parametersSELECT * from V$resource_limit; More convenient to view process and
Busy work every day, ah, really busy, today in the work of a small problem, is the oracle of the user name, Oracle does not seem to provide a statement such as rename, so can only directly change the lower view, this is my experimental resultsSELECT
First step, on the cmd command line, enter SqlplusStep two, follow the prompts to enter the user name and password1. View processes and Sessions parametersSql> Show parameter processesNAME TYPE VALUEDb_writer_processes Integer
Oracle Table Replication1>create table ... as select:, the table does not exist, and the tables are created and the data is copied. Use this statement in cases where the table does not exist in the oralce.CREATE TABLE newtable as SELECT * from
The command we met todayIPCsShow SGASelect Component,granule_size from V$sga_dynamic_components;Alter system set shared_pool_size=64m;-->64m can be changed to change the size of the shared pool.The SGA mainly includes the following:Shared
1. Case-When expressions have two forms--Simple Case function Case Sex When ' 1 ' Then ' men ' When ' 2 ' then ' women ' Else ' other ' END --case search function CaseWhen sex = ' 1 ' Then ' man ' When sex = ' 2 ' Then ' women ' Else ' other
1.1 symptom description when the following SQL statement is imported, garbled characters are displayed in the database.
Insert into CONFERENCE (values, values, ACCESSNUMBER, ACCOUNTID, ALLOCATEDID, ALLOWVIDEOCONTROL, SCREENTYPE, values, BOARDNUM,
1. Role: A combination of Permissions
Custom roles and predefined roles
2. Custom roles: dba, connect, and resource
Predefined roles:
3. Delete permission: revoke XXX from XXX;
4. delete a user: drop user XXX cascade;
Cascade: If you have
We often use Oracle to search for user tables in Oracle databases. Among the many combined queries, using Oracle to Search user tables can greatly improve the query speed, the following provides specific instances based on several different
After a long period of development in Oracle, many users are familiar with the Oracle user table. Here I will share my personal understanding and discuss it with you. Create a new account on an existing database instance to access some new Oracle
Oracle is still quite common, So I studied Oracle selectivity. This article compares the number of unique keys in the column and the number of rows in the table to determine the Oracle selectivity of this column, I would like to share it with you
Oracle alter tablespace
1. Find out which tables have incorrect tablespaces.
select * from dba_tables where tablespace_name='TDB';2. Move the tablespace in TDB to TDB2009.
Syntax: alter table table_name move tablespace tablespace_name; alter table
Modify the column data type.
Author: David _zhang @ sh: [mark the article in hyperlink form when reprinting]
Link: http://www.cnblogs.com/david-zhang-index/archive/2012/04/10/2441015.html
Field operations
Procedure
Update field
Role of TNS in Oracle
What is TNS?
TNS is a part of Oracle Net. It is a tool used to manage and configure the connection between the Oracle database and the client. In most cases, to communicate with the database, TNS must be configured, of course,
Processing of OracleTIMESTAMPPublic class Test {Private static final SimpleDateFormat FORMAT = new SimpleDateFormat ("yyyy-MM-dd HH: mm: dd ");Public static void main (String [] args) throws SQLException {Oracle. SQL. TIMESTAMP temp = new oracle.
SQL optimization: optimization of the connection sequence, condition sequence, in and exist of count and table, countexist
This article describes how to optimize the connection sequence, condition sequence, in and exist of count and table in SQL
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
/*==============================================================*/ /*
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