Friday, 2 November 2018

Migration from 10g to 18c using datapump

on new server
++++++++++++

1)change the database in no archive mode
2) drop the users
3)new_sql_objects
4)dbmon_create_initial
5)create dssadmin.sql
5-1)create user password
5-2)database link
6)impdp.par
7)compile invalid objects and stats
8)make_statements.sql
8.1)grant special
9)check constraints
10 grant omnixpress
11 check partition
12 change_user password
13)archive mode


coming soon ....

No comments:

Post a Comment

Featured post

duplicate db from standy to other server

 Duplicate Testuat   $ export ORACLE_SID=Testuat3 $ sqlplus '/as sysdba' Testuat3 SQL> alter system set cluster_database=FALSE sc...