DATA MIGRATION FROM 8.1.7.0 TO 10.2.0.1

DATA MIGRATION FROM 8.1.7.0 TO 10.2.0.1

 (One server to another server to be migrate DB – Using export/import)
Pre-check and post-check:

SQL> select sum(bytes)/1024/1024/1024 from dba_data_files;
SQL> select sum(bytes)/1024/1024/1024 from dba_segments;
SQL> select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;
SQL> select tablespace_name,sum(bytes)/1024/1024 from dba_segments group by tablespace_name;
SQL> select  count(*) from dba_users where username not in (‘SYS’,’SYSTEM’);
SQL> select owner, count(*) from dba_tables where owner not in (‘SYS’,’SYSTEM’) group by owner;
SQL> select  owner,count(*) from dba_indexes where owner not in (‘SYS’,’SYSTEM’) group by owner;
SQL> select owner, count(*) from dba_constraints where owner not in (‘SYS’,’SYSTEM’) group by owner;
SQL> select owner, count(*) from dba_objects  where owner not in (‘SYS’,’SYSTEM’) group by owner;
SQL> select ownwer, count(*) from dba_tables where owner not in (‘SYS’,’SYSTEM’)  and status <> ‘VAlID’ group by owner; Notes:Export è source db check pre check
Importè destination db check post check

·         10g db create with same 8i structure, what r the DF size,tbs name & size to be create in same 10g new server.
 

Target server 8.1.7.4.0

 $.oraenvORACLE_SID:prod
$ sqlplus “ / as sysdba”
SQL> shutdown immediate;
$ lsnrctl stop <Listener_name>
$ sqlplus “ / as sysdba”
SQL> startup restrict
SQL> exit;
$ exp \’/ as sysdba \’FULL=Y file=full_prod.dmp BUFFER=157286400 STATISTICS=NONE LOG=full_prod.log (Dump file only to be copy 8i to 10g)
$ scp –r full_prod.dmp oracle@192.168.1.102:/opt/oradata Destination Server 10.2.0.1.0

$.oraenvORACLE_SID:prod$ sqlplus “ / as sysdba”
SQL> select instance_name,status from v$instance; 
SQL> select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name; (8i what r the tbs there that tbs size must be equal or not to be check in 10g.)

$ imp \’/ as sysdba \’FULL=Y file=full_prod.dmp buffer=157286400 statistics=none log=full_prod.log