Oracle

Create a tablespace Create tablespace ICITY datafile 'd: \ Oracle \ oradata \ orcl \ ICITY. dbf' size 400 M autoextend on next 10 M maxsize unlimited extent management local; Create temporary tablespace Create temporary tablespace ICITY_TEMP

The first six notes are Table query operations. As a basic operation of the database, query takes a lot of time. In this note, we will learn how to create and manage tables, create tables, Delete tables, modify tables, rename tables, and clear

2 tablespace The maximum logical layer in Oracle disk management is the tablespace. The four tablespaces that must be created in Oracle11g are SYSTEM, SYSAUX, TEMP, and UNDOTBS1. 2 SYSTEM: stores data dictionaries, pl/SQL code, etc. 2 SYSAUX: stores

Use Vertica to construct a calendar:SELECT to_number (TO_CHAR (ts: DATE, 'yyyymmdd') as day_id,Year (ts: DATE) as year_of_calendar,Month (ts: DATE) as month_of_year,Dayofweek (ts: DATE) as day_of_weekFROM (SELECT '01-01-2013 ': TIMESTAMP as

--- Indicates flashing back to the database --- Use a flashback table to restore the table content to a specific time point in the past --- Restore from the deleted table --- Use the flashback query to view the database content at any point in time -

Environment:Platform: RedHat EnterPrise 5.8 X86_X64Database: Oracle EnterPrise 11.2.0.3Cluster software: Oracle grid 11.2.0.3 Fault symptom:An archive failure occurs in the database, and an instance of one node is HANG dead. The log information is

Today, I encountered a strange problem at oracle10g. One SQL statement was very fast on database 1 and very slow on Database 2. Database 2's data was imported from database 1 and the data volume was similar. Run 0.01 s on database 1. SQL> SELECT .*,2

1. Capture representative SQL workloads1.1. Create an SQL adjustment set (STS)SQL> exec dbms_sqltune.create_sqlset (sqlset_name => 'SQL _ test', description => '11g spa test ');PL/SQL procedure successfully completed.1. 1.1. Load the SQL statement

Manually back up archived logs 1. database01 [Oraprod @ db01 scripts] $ pwd/Usr/tivoli/scripts[Oraprod @ db01 scripts] $ ls1. txt nohup. out oraicr0.sh scheoraicr0.shBKlog null oraicr1.sh scheoraicr0.sh. testBKlog.tar oraarch. sh oraicr1.sh. orig

1. If it is just deleted, there are two methods: Run the show parameter undo command to view the current database parameter undo_retention settings. Shown as follows:Copy codeThe Code is as follows:Undo_management string AUTO Undo_retention integer 1

ORA-01002: fetch out of sequence Error locating: SQL>! Oerr ora 01002.01002,000 00, "fetch out of sequence"// * Cause: This error means that a fetch has been attempted from a cursor// Which is no longer valid. Note that a PL/SQL cursor loop//

This ppt systematically introduces the memory and storage management of Oracle11g, the main directory is as follows: 1. Memory Overview: -- SGA Parameters -- Automatic Shared Memory Management -- Oracle 11g parameter setting suggestions --

Solution for Oracle10g failure to start the service after the computer name or IP address is modified The cause of the problem is unknown. The problem is that an oracle service in windows cannot be started and the following error is returned.Windows

1. view the database version SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production PL/SQL Release 11.2.0.1.0 -

I used Oracle table partitions today. Let's write a few examples to explain the partitions in this table: I. Create a partition table 1. Range partitioning Partitions Based on the range of data table Field Values For example, you can partition a

1.Oracle server Character Set QueryCopy codeThe Code is as follows:Select userenv ('language') from dual; Server Character Set Modification: Start the database to RESTRICTED mode and make character set changes:Copy codeThe Code is as follows:SQL>

In 11g, statistics are automatically collected at PM (Monday to Friday, 4 hours) and am (Saturday, Sunday, 20 hours) by default ), as follows: select a.window_name, a.repeat_interval,a.duration from dba_scheduler_windows a,

When calling the dynamic performance view related to Oracle in a process, package, function, or trigger, you must grant appropriate permissions. Otherwise, you will receive an error message indicating that the table and view do not exist. Even if

At work this morning, the customer called and said that the system could not be accessed. the user name and user number could not be loaded! When I heard this problem, I first thought about whether the server was restarted. Why was Oracle database

The Function Room of the Database Control Language controls the user's access permissions to the database. The DBA determines the operation permissions of a user on a certain type of data. Oracle GRANT permissions using the GRANT statement and