Find Users Tablespaces.

How will you find out the user(scott) belongs to which tablespaces? (in Oracle)

Showing Answers 1 - 2 of 2 Answers

Shivam

  • May 9th, 2023
 

SELECT default_tablespace FROM dba_users WHERE username=SCOTT;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions