- Connect to sqlplus: sqlplus => system => password1 OR sqlplus system/password1@sonlmdb
- Show current user: show user;
- Show current database: select * from global_name;
- OR select instance_name from v$instance;
- Create user: create user identified by ; 
- Grant permission for user: grant connect,resource to ; 
Tuesday, April 19, 2011
Oracle SQLPlus
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment