CODEWITHSUNDEEP
sqldatabaseoracle-databaseoracle-sqldeveloper
Jemru
Jemru

Reputation: 2119

How to find Oracle SYSTEMDB Tables

I have an existing database and sql queries.

The query below works and returns rows. 

Select * from systemdb.TABLE_A;

However when I tried to find the "TABLE_A" table using "Oracle SQL Developer", I cannot find it in the Tables or Views tree list.

Would like to ask where can I possibly find this table?

What is the meaning of "systemdb" keyword in the query above?

Thank you very much.

Upvotes: 1

Views: 87

Answers (2)

Kim Berg Hansen
Kim Berg Hansen

Reputation: 2019

In that query SYSTEMDB is the name of a schema in the database. A schema is almost synonymous with a user.

In SQL Developer you are presumably logged in as a different user than SYSTEMDB. To see the tables belonging to SYSTEMDB you expand "Other Users" at the bottom of the tree, then you find SYSTEMDB and expand that one, and then you can find "Tables" or "Views" of the user SYSTEMDB.

Upvotes: 1

Patrick Hofman
Patrick Hofman

Reputation: 156948

It seems to be a tablespace / user created by PeopleSoft PeopleTools. There is not much to be found on it, but I found it here:

have to prepare 4 environmets with PeopleSoft... If there any documentation when you create SystemDB?

Upvotes: 1

Related Questions