| Imort data to Database [message #147151] |
Tue, 15 November 2005 23:21  |
rassul_2000
Messages: 1
Registered: November 2005
|
Junior Member |
|
|
|
I exported user from my database with 'exp' utility, then i deleted this user from database, and tried to import from .dmp file, but it said that user doesn't exists... Then i created user with same name, tried to import again and it said that importation past successfully without warnings, but i don't see any grants for this user, what am i doing wrong?
|
|
|
|
| Re: Imort data to Database [message #147168 is a reply to message #147151] |
Wed, 16 November 2005 00:56  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
I think you'll find that EXP only exports objects (tables, indexes, sequences, packages, etc) and your grants to other users on those objects. The roles and privs of the user itself do not get included in this type of export, and were destroyed when you dropped the user. You would probably need a full-database export.
DBA-type people, correct me if I'm wrong.
_____________
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
