Posted: February 11, 2012 in Random Posts

Java Tutorials

To know the current user in Oracle

select user from dual;

Steps to know list of users in the Oracle database.

Connec to dba user

conn sys/password as sysdba;

execute below query to get list of users

select * from dba_users;

To select only user names:

select username from dba_users;

To know the full details about the user:

select * from dba_users where username=’scott’;

To get the Table space name:

select tablespace_name from dba_tablespaces;

To list the username and size of the user:

select owner,sum(bytes) from dba_segments group by owner;

View original post

Advertisements
Comments
  1. Hipolito Handelsman says:

    I don’t normally comment but I gotta say thankyou for the post on this great one : D.

    Like

  2. credit card consolidation says:

    certainly like your website but you have to check the spelling on quite a few of your posts. Several of them are rife with spelling issues and I in finding it very bothersome to tell the truth then again I’ll certainly come again again.

    Like

  3. Eva Angelina says:

    Very good info can be found on site.

    Like

  4. blackjack strategy card says:

    Its such as you read my thoughts! You appear to understand so much about this, like you wrote the e-book in it or something. I believe that you can do with a few p.c. to power the message home a little bit, however instead of that, this is excellent blog. A fantastic read. I will certainly be back.

    Like

  5. physician assistant job description says:

    You have remarked very interesting details! ps nice internet site.

    Like

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s