| tables and users [message #279491] |
Thu, 08 November 2007 15:21  |
martiball10
Messages: 1
Registered: November 2007
|
Junior Member |
|
|
I need some help with my homework...
i cant figure out how to do these two problems...
7. Display all TABLES in DBA_TABLES that are in TABLESPACE CIS4740. Only the table name.
8. Display all USERS in the DBA_USERS table that have CIS4740 as a DEFAULT_TABLESPACE.
I know part of it is select * from dba_users; but i dont knwo how to specify the tablespace
thanks for the help in advance!
|
|
|
|
|
|
|
|
| Re: tables and users [message #279592 is a reply to message #279491] |
Fri, 09 November 2007 04:37  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
|
Did it ever occur to you that it might take you less trouble to find these answers yourself instead of posting it to every forum that has even the slightest relation to Oracle?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
