d'abord creer le user dans l'autre environnemnt
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
set long 9999999
spool user_script.sql
SELECT DBMS_METADATA.GET_DDL('USER', USERNAME) || '/' DDL
FROM DBA_USERS
UNION ALL
SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT', USERNAME) || '/' DDL
FROM DBA_USERS
UNION ALL
SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT', USERNAME) || '/' DDL
FROM DBA_USERS
UNION ALL
SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT', USERNAME) || '/' DDL
FROM DBA_USERS;
spool off; |
apres
faire un export
exp system/pass rows=N (si uniquement structure) file=... owner=ton_schema
sur l'autre base
tu crees d'abord le user
apres
imp system/pass full=y file=... log=imort.log
Partager