Oracle Migration

Objective: 

To transfer all kind of objects via exp / imp

Checks:

Login to Windows Server

Go to command prompt

sqlplusw.exe user/password@servername

SELECT * FROM V$VERSION
or
SELECT version FROM V$INSTANCE
or
BEGIN DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE); END;
or
select ora_database_name from dual;  -- database name
SELECT sys_context('USERENV','DB_NAME') AS Instance
FROM dual;  --- instance name

Question:  I wish to display my ORACLE_SID variable.  How do I find the value of ORACLE_SID?  -- Oracle sid is nothing but instance name

Answer:  There are several commands, some internal and some external to Oracle that will find your current ORACLE_SID.  Within Oracle (SQL*Plus) you can display your ORACLE_SID with any of these commands:

   select distinct sid from v$mystat;
   select * from global_name;
   select instance from v$thread;

select owner,count(*) as counts from dba_tables group by owner;

select owner,object_type,count(*) as counts from dba_objects group by owner, object_type;