Oracle

---delete partitions 6 months ago (local primary key, index)[Email protected] ~]$ cat/home/oracle/del_t_test_aa.sh#!/bin/bashSource/home/oracle/.bash_profiledel_date=$ (date-d ' 6 month ago ' +%y%m)#DEL_DATE =$ (DATE +%y%m)Partiname= "P"

This procedure applies to Oracle data volume statistics.Create or Replace procedureSp_get_tab_count asv_tablename HDSD_TJ. Tablename%type; V_tablecount HDSD_TJ. Tablecount%type; V_tmpvarchar2( -); V_TMP2varchar2( -); V_tmp3varchar2( -);

1. Current Situation 1.1 table space is not properly planned, causing all tables under all users to be created under the default table spaceOracle does not use a specific table space plan for a particular data table, resulting in the default

After the new Zabbix configuration, the company all the host is through automatic registration completed the addition of network equipment and its templates from the old Zabbix export template, and then import into the new Zabbix system. Some

Ideas:1. Use crontab to achieve timed tasks2. Execute the EXP backup instruction with Shell script**************************************Configure the crontab.CRONTAB-E Add regular execution instructions (and print the execution log):0 at 5 2>&1*****

Attention1: The column of the incoming DataTable must be the same as the table column in the database, otherwise the data will be saved by defaultThe 2:sql statement is intended to determine the table name as long as it is a query to the table to be

What is a connection:Use a connection to query data from multiple tables.Select table1.column,table2.column from table1, table2 where table1.column=table2.columnThe condition in which the join is written in the WHERE clause because there is the same

1, the implementation of theSelect from where = b.address;2. Executed (this method benefits to see the SQL executed at a certain time period, and the Sql_fulltext packageSelect from where between ' 2018-04-09/09:24:47 ' and ' 2018-04-09/16:24:47 '

Tag: Dex limit syn file role fallback character Dict Ace Using the SYS or System/manager as SYSDBA; Connect to the database. Create a regular user konglin:create users konglin identified by Pwd_oracle;Delete users, drop user Konglin; Grant

In the process of developing a project using Python, it is sometimes necessary to use a script to invoke Oracle, but garbled, the solution is as follows:The following sentences need to be added to the Python script you are writing:Import

First, when establishing the table, pay attention to the role of pctfree parametersPCTFREE: The percentage of space reserved for a block, indicating when the data block can be insert, the default is 10, indicating that when the free space of the

Insert All intojk_tb_date (Fbmmc,fgzjh,fsbmc,fsbxh,fsbbh,db_shuifenyi,db_pihao,db_wuliaobianma)Values('Inspection Department','102','Moisture Tester','sdwe-bzdhx-15','hx001','Moisture Meter',' One',"') intojk_tb_date

In this tutorial, you will learn how to use the Oracle BETWEEN operator to select row data in a range of values.Introduction to the Oracle between operatorBETWEENoperator allows you to specify the scope to test. When using the BETWEEN operator to

Open the computer in the morning, CRT full screen 4031, the head is friedMon Mar 05:55:25 CST 2018Errors in FILE/U01/APP/ORACLE/ADMIN/OMS10G/BDUMP/OMS10G_CJQ0_23214.TRC:Ora-00604:error occurred at recursive SQL level ora-00604:error occurred at

First, the use of rownum pagination is not a sort operationSELECT * FROM (select RowNum rn,t.* from Test_packet t)where RN between 1 and 10Execution results are as followsSecond, if the above SQL plus sortExecution results are as followsThe result

--I am the annotation information SQL statement--Creating User: Create user username identified by password;Create UserJack identified byj123;--lacks CREATE SESSION priviledge user does not have permission to connect to the database--Authorized User:

Method One: The version number is displayed when you log in [[email protected] ~]$ sqlplus/as sysdbasql*plus:release 11.2.0.3.0 Production on aweary Juan 7?20 17:51:14 2015Cop  Yright (c) 1982, Oracle. All rights reserved. Method Two:sql> select *

When building django+oracle 11g on a Win7 system, note that the example uses Python 2.7:Important: Python, Oracle, Oracle client these three OS bits must be the same, otherwise Python cannot connect to the Oracle database.

Write DMP files to aws rds oracle using Python scripts, pythonaws RDS (oracle) does not directly support SSH or FTP (based on security factors). Therefore, the dmp files from the original system expdp or exp cannot be directly imported into RDS. In

Basic Oracle Database Operations (5) -- use java to call stored procedures and oracle stored procedures I. Environment preparation Log on to the Oracle database scott account and use emp to perform operations. 1. Create the proc_getyearsal Stored