IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: July 2007

Installing Apache 2.2.4 in UNIX

Leave a Comment Posted by on July 26, 2007

You can carry out a basic standalone installation of Apache 2.2.4 on UNIX using the below mentioned steps. Required steps are written and can be understood easily. The below steps are taken from official Apache Org site. Step 1) Getting the Apache 2.2.4 dumps You can get the software dump for Apache from official Apache.org [...]

Oracle Middleware

Upgrading database to 10.2.0.2.0

Leave a Comment Posted by on July 19, 2007

Introduction and scope: This document is intended for those which are having 10.2.0.1 database installation and intended to upgrade the same to 10.2.0.2, by applying 10.2.0.2 patchset. This document is based on Metalink note ID 316900.1. Follow the below procedure for upgrading the database from 10.2.0.1 to 10.2.0.2 Pre-Requiste: We are assuming that you have [...]

Oracle Database 10g

Renaming a tablespace – Oracle database 9i and 10g

2 Comments Posted by on July 12, 2007

Oracle 9i: SQL> CREATE TABLESPACE test1 DATAFILE ‘/u01/app/orsbox/proddata/test1.dbf’ size 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Tablespace created. For Renaming the tablespace, we don’t have a direct command in 9i. For that we need to follow the below steps. 1) Export all of the objects from the tablespace [orsbox@ocvmrh2124 9.2.0]$ exp system/manager FILE=test1.dmp LOG=test1.log [...]

Oracle Database 10g, Oracle Database 9i

Follow

Get every new post delivered to your Inbox.

Join 156 other followers