Oracle Common Commands

Import/Export Database:

exp username/password@tns name FILE=D:\pub.dump OWNER=(username)

 

imp username/password name FILE=D:\pub.dump TOUSER=(username) FROMUSER=(username)

 

Query all users in the database:

select * from all_users;

 

Check the resource limits in oracle:

select * from v$resource_limit;