You won't loose the grants. When the import imports the table, the following takes place....create the table, import the rows, create the indexes,triggers,constraints,give grants.
If you take a schema export, you can effectivly go into the database and drop the user cascade, recreate the user and run the import and it will be just like it was before you started the process.
also executing the following will help you see the light 
imp help=y
Last edited by OracleDoc; 11-04-2004 at 09:26 AM.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
Reply With Quote