1) Take the tablespace offline ALTER TABLESPACE tablespace-name OFFLINE; 2) Use the OS to Move the tablespace to the new location 3) Run the following command: ALTER TABLESPACE tablespace-name RENAME DATAFILE ‘OS path to old tablespace\tablespace-datafile- name.dbf’ TO ‘OS path to new location\tablespace-datafile-name.dbf’; 4) Take the tablespace back online ALTER TABLESPACE tablespace-name ONLINE; If the following error ...
I. Download patch set p5337014_10203_WINNT.zip II. To install the Oracle Database 10g patch set interactively: Log on as a member of the Administrators group to the computer on which you are going to install Oracle components. If you are installing on a Primary Domain Controller or a Backup Domain Controller, log on ...
Sqlnet.ora is a text file that provides SQL*Net with basic configuration details like tracing options, default domain, encryption, etc. This file can be found in the ORACLE HOME\NETWORK\ADMIN directory. It can be used to enable/disable trace. Reference: http://www.orafaq.com/wiki/Sqlnet.ora#Sample_sqlnet.ora_files http://users.handysoft.co.kr/~jelong/net_para.txt http://www.dba-oracle.com/t_tns_12560_protocol_adapter_error.htm
The error "TNS-12560: TNS: protocol adapter error" is usually related to a configuration issue with the listener: TNS-12560 TNS:protocol adapter error Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting this error, look ...
If you are trying to add a new Not NULL columns to a table and you get the following error: ORA-01758: table must be empty to add mandatory (NOT NULL) column Since the values in the new column are null (after all, you just added the column) the new constraint can ...
Oracle/PLSQL: NVL Function In Oracle/PLSQL, the NVL function lets you substitute a value when a null value is encountered. The syntax for the NVL function is: NVL( string1, replace_with ) string1 is the string to test for a null value. replace_with is the value returned if string1 is null. Applies To: Oracle 8i, Oracle ...
Oracle =========================================================== Books: Database Concepts ----------------------------------------------------------- Database Structure and Space Management ----------------------------------------------------------- Logical Database Structure * Schema/Schema object(the logical structures that directly refer to the DB's data a schema is owned by a user who has the same name as the schema) Table View Index Cluster * Data block * Extent * Segment * Tablespace Online(accessible)and Offine(not accessible) * Databse, TableSpaces, and Datafiles Physical Database Structures * Datafiles (the charateristics of ...
If you administer a busy database you will see this error from time to time. It is nothing to worry about, but it can be quite annoying when it stops you from doing something. It simply means that session has a lock on an object that your session is trying to ...
第一章：日志管理 1.forcing log switches sql> alter system switch logfile; 2.forcing checkpoints sql> alter system checkpoint; 3.adding online redo log groups sql> alter database add logfile [group 4] sql> (`/disk3/log4a.rdo`,`/disk4/log4b.rdo`) size 1m; 4.adding online redo log members sql> alter database add logfile member sql> `/disk3/log1b.rdo` to group 1, sql> `/disk4/log2b.rdo` to group 2; 5.changes the name of the online redo logfile sql> alter database ...
SQL*Plus — schemata — data types — DML & DDL examples — editing commands — using external files — the dual pseudo-table — introduction to transactions — optional exercise — references Introduction During this tutorial you will build on your databases knowledge by learning the fundamentals of Oracle, one of ...