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 1000+ 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 Connor 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)

Is this answer out of date? If it is, please let us know via a Comment

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

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

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