Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Finding information??
Hello folks,
I have been asked to find all thr schemas in and instance, and each table
containted
within. Our DBA left and I have been given the DBA responsibilities for the
interm.
Is there a table/view I can get all the schemas from? Also, is there a way
to show the
tables that have been created under each schema?? We are looking to find
which table
stores user account information.
Thanks for any information,
![]() |
![]() |