Oracle

--Table Space fileSELECT * from Dba_data_files;--Table space occupancySELECT A.tablespace_name,a.bytes/1024/1024 "Table space size (M)",(a.bytes-b.bytes)/1024/1024 "used Space (M)",b.bytes/1024/1024 "free Space (M)",Round (((a.bytes-b.bytes)/a.bytes)

Http://www.cnblogs.com/hxw/archive/2005/09/11/234619.html1. According to rowID to divideSELECT * from T_xiaoxi where rowID in (the Select Rid from (select RowNum rn,rid from, select rowID rid,cid fromT_xiaoxi ORDER BY cid Desc) where rownum9980) the

Oracle View native Service nameSelect Global_name from Global_name;Database Listener.ora# Listener.ora Network Configuration File:e:\app\chenjz\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration

1. Using Oracle features in MyEclipseData processing is required to develop applications in MyEclipse, and you can access many of the capabilities of the Oracle database directly.Browse, create, and edit Oracle types: Alias View

Introduction Intra-company projects tend to implement business logic in Oracle stored procedures, so each project upgrade involves the upgrading of database objects such as many Oracle tables, stored procedures, and so on. However, the upgrade

1. Create user (requires DBA authority to log in)Create user username identified by password;After you create a user, you authorize it, and if you do not authorize it, you will not be able to log in to the database or do anything:Grant

Oracle modifies table space sizeAfter the database was established using ORACLE10G, some data was imported into the database and an error occurred the next day when the data table was imported to the database:It's a lot of data. The reason why the

In recent days has been the problem of oracle-sql, involving a number of things that are not used in peacetime, and therefore here depressed for a long time. Now the problem has been solved, though not perfect. But let's share it with everyone. One

1. Descartes SetSELECT * from EMP, dept;2. Equivalent connectionSelect ename, Job from EMP, deptwhere Emp.deptno=dept.deptno;3. Non-equivalent connectionSelect ename, grade from EMP, SalgradeWhere Sal between Losal and Hisal;Actually, I don't quite

1. What does the index do?Answer: The index is used in the database to improve query efficiency.Add: Too many indexes can significantly reduce the efficiency of DML statements, and the principle of indexing is to build on fields that are frequently

1, export the name of a table (here will export sequences and function and other content)EXPDP Test/test@orcl schemas=Test DumpFile=test.dmp DIRECTORY=Db_bak EXCLUDE=TABLE: \ "not in \ (\'a\') \"2, export the name is not a table (remove not and we

Switch to Oracle UserSu-oracle #目录转到oracle用户的HOME下, together with the user's shell to switch, only the environment variable that switches Shell,path is valid. Su only switches identities, and the shell environment is still the original user's shell

1. View the table space and the corresponding nameSql> SELECT file_name,tablespace_name from Dba_data_files;2, query the system users and the corresponding table spaceSql> select Username,default_tablespace from Dba_users;3. Query the table space of

SummarizeSub-query：Single-row subquery: return single rowUsing single-line comparison operatorsMultiline subquery: Multi-row subquery returns multiple rowsMultiline operators:In, Any,allIf the subquery query result is empty, no rows are

Error logging: Invalid source path '. /stage/components/oracle.jdk/1.5.0.17.0/1/datafiles ' specified for unzip. This error should be I only unzipped the first compressed package, not decompression the second one.2. Another problem is that

Tag:oracle    archive    archive   archivelog    Turn on archive mode> Archive log list;> Shutdown Immediate;> Startup mount> ALTER DATABASE Archivelog> ALTER DATABASE open;> Archive log list;View Archive mode while still looking at archive storage

An error encountered during the use of spring+mybatis+oracle.Finally see the online sharing to solve this problem, mark.The main problem is that the configuration of the mybatis is problematic. I'm going to copy it right here.Original link:

The purpose of the SQL Union All directive is to merge the results of the two SQL statements together. The difference between SQL union All and SQL Union is that SQL Union all lists every qualifying data, regardless of whether the database is

The use of the--oracle trunc () function/************** Date ********************/1.select trunc (sysdate) from dual--2011-3-18 today's date is 2011-3-182.select trunc (sysdate, ' mm ') from dual--2011-3-1 returns the first day of the month.3.select

Case of Oracle listening service startup failure and oracle listening failure When a database is restored on the ORACLE test server, errors such as TNS-12541, TNS-12560, and TNS-00511 occur when the listening service is started, as shown