Check with

select * from dba_users;

Alter the password with

alter user schema identified by new_password;

Wmp

One you can use Oracle Enterprise Manager

Or from sqlplus using this command select distinct owner from dba_objects;

Instead of 'select *':  select username

I'm no Oracle expert either, but try these:

SELECT username FROM all_users ORDER BY username;

alter user <user_name> identified by <new_password>;

Guys, How can I use Oracle Enterprise Manager? I think that the GUI of using Oracle Enterprise Manager would be best.

I have the Oracle client intalled with admin stools but i don't see Oracle Enterprise Manager. Can someone help me with access to OEM?

Thanks

>>Can someone help me with access to OEM?

OEM is now browser based as of 10g.  The 9i OEM fat Java version still works against a 10g database.  After that:  Either dbConsole inside the database itself or Grid Control for managing multiple instances.   Either way:  Browser based.

>>I think that the GUI of using Oracle Enterprise Manager would be best.

Opinion.  I prefer sqlplus and a simple select statement.  But, that is just me.  Besides, OEM doesn't offer a SQL worksheet like SQL Developer, if you like GUIs.

Suggest that you use SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Last thing Guys, whats the SQL command to search for ALL tablespaces in the Oracle DB?

>>whats the SQL command to search for ALL tablespaces in the Oracle DB?

This is a different question.

All the data dictionalry views are in the docs:
select tablespace_name from dba_tablespaces;


Keep this SQL handy:
select view_name from dba_views where view_name like upper('%&view_to_find%') order by 1
/


I call it: find_view.sql

When you execute it and prompted, just enter a partial word like tablespace and it will show you ALL the views that are like that term.

99% of the time a view will pop up and it will be obvious what one you need.

@slightwv,

With the SQL you provided: select view_name from dba_views where view_name like upper('%&view_to_find%') order by 1

Are you suggesting that I take that one line and paste it in Notepad and save it as...  .SQL file? then upload it to my Oracle DB Linux server  location?

If so, how would I run that script from the Linux server? Not sure how to execute sql scripts on Oracle Linux server.

I just need more detailed steps. Thanks

>>then upload it to my Oracle DB Linux server  location?

Save it where ever you run sqlplus from.  To execute the script from sqlplus:
SQL>@find_view

by default sqplplus looks for scripts in the folder you execute sqlplus from.  If you save it to another folder:
SQL> @/some/path/find_view

Ok. I just copied your SQL and pasted it into my Sqlplus session. See results below. It still doesn't list all of my tablespaces. Did I not enter the correct info? when it prompted me I entered: tablespace.

But I know I have tablespaces called: PRODDTAT, PRODDTAI, TESTDTAT, TESTDTAI, etc, etc.

That shows you the views within the system this is not showing you the tablespaces.

this will show you the view for tablespaces:

select tablespace_name from dba_tablespaces;

dariusg,

I already posted that exact query in http:#a37827849

The rest of the SQL was for future help in finding the correct view.

Please read all previous posts before posting.

slightwv,

I was explaining to him what you put. I wasn't trying to post the same thing over again.

"this will show you the view for tablespaces:" comes across as posting duplicate information not explaining a previous post without a reference to a previous post.

I got it guys. Thanks for explaining all this Slightwv. I appreciate it.

@slightwv

As you can see the first part of the second sentence was cut off which was pointing back to your post.

Look I have been an expert for a while on EE check my credentials.

Thanks!