0

I have two question about oracle export and import.

First of all,I want to export only user and their roles not tables,trigger and other object Later import user

How i can do?

Other question is while importing operation, can i get error?Because, which object importing early roles or user? Unless importing roles, user can't assign roles?

Serdar Alkan
  • 181
  • 1
  • 4
  • 15

1 Answers1

0

You must be using ddl statements, look How to clone user in Oracle and https://dba.stackexchange.com/questions/30337/duplicate-an-oracle-database-user ,and if you are using SQL Navigator, you can select user in the tree (press F12) and press Ctrl+D

Community
  • 1
  • 1
Andre Kirpitch
  • 1,027
  • 11
  • 18