Compare two schemas

Toad for Oracle - Beta
1

I'm trying to compare two schemes:

Database->Compare->Schemas

I remove all checkboxes leaving only "Tables", run and get next
error

Why did this function require DBA rights?

2

We are selecting tablespace information because you left the Storage option enabled.

Go here and uncheck "Compare storage clause", then you won't get that message.

image
image598×671 15.6 KB

I'll take a look at this later today and see if it's really necessary to select from DBA_TABLESPACES to perform the storage comparison.

3

Ups, I really didn't clear the checkbox there... but after I got this
error2
:slightly_smiling_face:

4

This is on your 23c (not 23ai) database? The VECTOR_INFO error will be fixed in next beta.

Also, I have taken a look at the original issue. The only views required in this case are DBA_TABLESPACES and DBA_TS_QUOTAS. I have made the following changes for next beta:

  1. The error message will be correct.
  2. You can just uncheck "Tablespaces" under "Compare Storage Clause" instead of "Compare Storage Clause" to avoid this SQL
  3. If you log in as the schema being compared, we will use USER_TABLESPACES and USER_TS_QUOTAS here instead of the DBA versions.