Oracle

SYSDBA users can log in, the normal user login error is as follows:[Oracle@dbserver ~]$ Sqlplus/nologSql*plus:release 11.2.0.1.0 Production on Mon Oct 17 21:07:09 2016Copyright (c) 1982, 2009, Oracle. All rights reserved.sql> Conn

Dba_free_space: Describes the remaining size of the data space Dba_data_file: Describes the total size of the data table space Select A.tablespace_name, A.bytes bytes_used, B.largest,round ((a.bytes-b.bytes)/a.bytes) *100,2) percent_used from (

The command is at the beginning--the command that can be entered in the--cmd--dos run. (1) command to open and close Oracle related services: Open service net start oracleoradb10g_home1tnslistener--This is listening, this service name may not be the

Here we are verifying an Oracle unconventional high efficient insert notation --Creates 2 test tables HYPER/HYPERW create table Hyper (a int); CREATE TABLE HYPERW (a int); --Insert 1 million records-note: This is a time consuming serious declare

A matter for attention when EXPDP and IMPDP use EXPDP and IMPDP: Exp and imp are client-side utility programs that can be used either on the client or on the server side. EXPDP and IMPDP are service-side tools that they can use only on the Oracle

1 Select all information about the employee in Department 302 List the number of employees whose position is (MANAGER), name3 Find bonuses above the salary of employees4 Find the sum of each employee's bonus and salary5 Find the manager in

Statistics by day Select COUNT (dataid) as number of operations per day, sum () From TableName Group BY Trunc (Createtime, ' DD ') By Natural Week statisticsSelect To_char (date, ' IW '), SUM ()From TableNameGroup BY To_char (date, ' IW ')Monthly

User name/Password login Identity descriptionSys/change_on_install SYSDBA or Sysoper cannot be logged in as NORMAL as the default system administratorSystem/manager SYSDBA or NORMAL cannot be logged on as a sysoper, as the default system

Oracle creates databases, tablespaces, users, and authorizes You can use the default database ORCL after installing Oracle database software, or you can create a custom database as needed. Table spaces are used to categorize resources in a database,

Create user Cmsuser identified by "Cmsuser"; Sql> create user Uumcuser identified by "password"; User created. Sql> Grant CONNECT,DBA to Uumcuser; Grant succeeded. Sql> Grant Exp_full_database,imp_full_database,resource,create any sequence to

1, Sqlplus Sys/password as SYSDBA admin login 2, create temporary table space Change the red part into your own path Create temporary tablespace mytestTempfile ' D:\app\Administrator\oradata\orcl\mytest.dbf 'Size 200mAutoextend onNext 200m

Problem Description:Aix-oracle database connections cause archive log full Solution:1. Delete Archive logs manually 2.rman Delete Archive Log$rman Target/Rman>select * from V$flash_recovery_area_usage;Rman>delete Archivelog from time ' sysdate-1

The weight of the word field View Duplicate data SELECT * from Testrepeat t where t.id in (select ID from testrepeat GROUP by ID has count (ID) > 1); Delete duplicate records, keep rowid the smallest rows Delete from Testrepeat t where t.id

recover data that was delete Suppose the table name is: Table_delete View System Current time --Get the system current timeSelect To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from dual; View the data in this table at a

When Oracle 11.1 is installed on the Redhat operating system, it is frustrating to encounter the inability to start the installation image interface after performing Runinstaller. Problem phenomenon: Using the Xmanager2.0 software to log on to the

First, Oracle's startup and shutdown 1, in a stand-alone environment To start or shut down an Oracle system, you must first switch to an Oracle user, as follows Su-oracle A, start Oracle system Oracle>svrmgrl Svrmgr>connect

1. Query user (data) Table space Select UPPER (f.tablespace_name) "Table space name",D.TOT_GROOTTE_MB "Table space size (M)",D.tot_grootte_mb-f.total_bytes "used Space (M)",To_char (ROUND (d.tot_grootte_mb-f.total_bytes)/d.tot_grootte_mb * 100,2),' 9

First, to improve the DML operation method: In short, 1, suspend the index, restore after the update. Avoid the rebuilding of indexes in the process of updating. 2, batch update, every update some records in time to submit action. Avoid large

Operating environment: Installing Tests on your own notebook computer Operating system version: 64-bit win8.1 Oracle version: 64-bit Oracle 11g Oracle successfully installed//logged on to Oracle as Administrator Enter command in cmd sqlplus/as

1. Create: CREATE SEQUENCE emp_sequence --sequence name INCREMENT by 1- -if omitted, the default is 1, and if negative, the value of the sequence is decremented by this step. Start with 1 -counting the Nomaxvalue from 1- without