Useful Select Statements

To view the default tablespace:

SELECT PROPERTY_NAME, PROPERTY_VALUE

FROM DATABASE_PROPERTIES

WHERE PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

To view the database name:

SELECT NAME FROM V$DATABASE;

Moving Data between two AIX Servers using Shared File System

 Part 1: Introduction:

This document describes how to move data between two AIX servers using shared file system. The concept used is that one machine share a file system over the network and allow other machines to access this file system. In our example the source machine that we move data from, is called Production Server and the destination machine that we move data to, is called Test Server, so we are moving data from Production to Test. Note that this approach can be used with clone purpose of Oracle Applications or database (Like In our case) or any other task that requires moving data between two server. The steps are as follows…