Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Gilroy.

Asked: March 31, 2021 - 4:33 am UTC

Last updated: April 12, 2021 - 5:23 am UTC

Version: Oracle Database 12C

Viewed 100+ times

You Asked

Hi

Any idea on what is a #hash view and creating triggers on #hash view?
If you know please leave a script/query for the same.

Schema Consolidation:
There multiple schemas, For ex:
Schema1
Schema2
Schema3
Schema4

Now i want to move all the objects & data of schema2, Schema3 & Schema4 to a new schema named SchemaAll.
How can i do that?
Note: Schema1 has some procedures, functions etc that use Schemaname.tablename(schema2.xyz), i need to take care of that too.



Thanks

and we said...

Sorry, I have never heard of a #hash view.

We have hash functions (ora_hash, standard_hash, dbms_utility.get_hash_value) and hash partitioning and hash clusters.

To consolidate schemas, you'll need to use something like DataPump to bring them all together.

But is there any significant issue that is forcing you to do that?

Rating

  (1 rating)

Comments

Gilroy Maynard Lobo, March 31, 2021 - 5:59 am UTC

I can use Data Pump, But does it take care of the thing that i have mentioned schemaname.tablename in procedures.

See i have those schemas, i am moving 2,3 & 4 to schemaall, after that 2,3 & 4 will be removed.

Now my concern is there are some procedures in my schema1 which used to do some DML in tables of 2, 3 & 4. For ex We had used schema2.tablename. Now since i am moving to schemaall i want it to be replaced with schemaall.tablename
Connor McDonald
April 12, 2021 - 5:23 am UTC

But is there any significant issue that is forcing you to do that?


Why consolidate?

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database