Oracle

--Bulk Modify the name of the table partition DECLARE V_sql VARCHAR2 (1000); BEGIN For X in (SELECT table_name, partition_name From User_tab_partitions WHERE to_date (SUBSTR (REPLACE (Partition_name, ' _ ', '),-6), ' Yy-mm-dd ' Add_months (TRUNC

Workaround: 1. Login with DBA role; 2, enter the following format command unlock: Alter user username account unlock; 3, if the password forgotten, enter the following format command to modify the password: Alter user username identified by new

Oracle databases sometimes accidentally delete data, want to query this data, or recover data, you can use a SELECT statement with the AS clause for a flashback query. Flash-back query for data from a time period in the past SELECT * from TB as

1. Update (SELECT ..... ) Set column1 = Column2; Update (select Iy.company_name company_name1, CC.COMPANY_NAME_JC company_name2From Income_year_item iy, City_company cc where Iy.company_code = Cc.code)Set company_name1 = Company_name2; 2. Only

Move Oracle database table space files. Objective: To move an Oracle Tablespace file from one place to another. Reason: The table space file in the current instance and the system table space file are all on one hard drive, resulting in an IO

Article copyright by the author Xiaohui and blog Garden Common, if reproduced please mark the source clearly: http://www.cnblogs.com/naaoveGIS/. 1. Background In the Leting project, the engineering colleagues put forward the need in the docking

Use Oracle users to execute the following script: #!/bin/bash source/etc/profile export Nls_lang=american_america. ZHS16GBK #Oracle的字符集, the Chinese character set for the Oracle database is American_america. ZHS16GBK #Oracle数据库的根目录 export

1, in the Powerdesinger design table (1) After downloading Powerdesinger, right key new-->physical data model default name is: Physicaldiagram_1, right key new-->table, start table design (2) Configuring an ODBC data source Configure the ODBC data

SQL: Method One: Select Dbf.tablespace_name, Dbf.totalspace "Total (m)", Dbf.totalblocks as Total block number, dfs.freespace "remaining total (m)", Dfs.freebl Ocks "Number of remaining blocks", (dfs.freespace/dbf.totalspace) * 100 "free proportions"

If your user does not have DBA authority and only wants to view the number of records for all of the tables in this user (note: Not all tables in the library you said), change to: EXECUTE dbms_utility. Analyze_schema (' MyUserName ', ' COMPUTE ');

Oracle queries all table records of users Because of the need to upgrade the application in the field, to assess the amount of data for security purposes, Oracle, a command can be done. One need to be aware that users with DBA authority are

  1.  explains the differences between cold and hot backups and their benefits    answers: Hot-backed databases for archive mode, backed up while the database is still working. A cold backup is a database that is backed up after the database is

First, copy the syntax of the table: Create table table name as (subquery) Example: Copy oracel the table EMP in the default database Scott after installation CREATE TABLE Myemp as (SELECT * from EMP); This example represents the table

DECLARE CURSOR Tab_cursor is SELECT table_name from user_tables;   V_table_name User_tables.table_name%type;   V_num number; V_P1 number;   BEGIN Open tab_cursor;      Loop fetch tab_cursor into v_table_name;      Exit when Tab_cursor%notfound;

ALTER index INDEXNAME rebuild partition partitionname tablespace spacename parallel 1 nologging; is a part of the above. How to see if the above statement was successful. (and not built how to compare to see.) ） 1. The above statement is a

When you turn on Oracle listening, you receive the following error message: Tns-12541:tns:no Listener Tns-12560:tns:protocol Adapter error tns-00511:tns:no Listener Linux error:lll:Connection Refused at this point, you check to see if your

Use the root user to manipulate the following: First, create a new folder in the $oracle_home/jdk/jre/lib/fonts directory fallback #mkdir fallback Second, from the window System windows/fonts copy SIMSUN.TTC font files to the new fallback

First look at the Oracle database encoding Sql> SELECT * from nls_database_parameters where parameter = ' nls_characterset '; PARAMETER -------------------- VALUE -------------------- Nls_characterset Al32utf8 This is derived from props$,

One, EM 1. View EM Status: #emctl Status Dbconsole 2, Start em: #emctl Start Dbconsole 3. Turn off EM: #emctl Stop Dbconsole 4, Rebuild EM: (Note: When the computer network environment changes, such as the cause of the EM can start, but the

First, start Oracle under Linux Log on to CentOS, switch to Oracle user rights # su–oracle Then enter: $ sqlplus "/as sysdba" The original picture will become Sql> Next, enter Sql> Startup You can start the database normally. In addition, the