var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: creating oracle user as that of existing user
I have two machines on which oracle is running....on one machine... one user is their.....I need to create same type of oracle user on other machine....!!!
How should i go for this...?? so that new user (on one machine) has the same priviledge and grants(everything) as that of existing user on other machine.
Any help will be highly appreciated ...!!!
Thanking in anticipation.
You can find a suitable script to help you do this here:
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.
How about using EXP(ort) and IMP(ort) utilities? If you need the whole schema (that is, user and its tables, views, grants, triggers, ...), perhaps you could consider this too.
By the way, if you will use Frank's script, don't forget to SPOOL output into some file (because running it as it is will not do anything) and run it on another database.