Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Copy table from once schema to another

Rahul_IndiaJul 1 2013 — edited Jul 3 2013

I have once schema say DEV_A .under this schema i have one user say T.

select * from  T.TABLE_NAME;

i want to copy the same table with data in another schema PROD_A  schema (prod_a also ha a usernamed t) under the user name T(IN PROD_A)

How can i do it

Comments

The namespace for an OPA Assess operation has specific meaning. There isn't an easy way to change it and you probably shouldn't.

Why do you need to override the namespace of the assess request and response?
smuralee

In order to have all the modules in the build to have the same namespace and as part of a convention, this requirement was provided.

Frank.Hampshire-Oracle

Suraj,

You could try changing the namespace in the OnReturnResultEventHandler but I would not recommend changing the namespace at all. As mentioned previously namespaces have very specific meanings and you probably should not do it.

You could also just change the assess velocity template and replace ${service.getTargetNamespace()} with your specific namespace. Same warnings as above.


Cheers

Frank

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 31 2013
Added on Jul 1 2013
#general-database-discussions
12 comments
16,160 views