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

Postgres commads

 [oracle@Tesdb ~]$ systemctl status postgresql-15 ● postgresql-15.service - PostgreSQL 15 database server    Loaded: loaded (/usr/lib/system...