1

Topic: How to load tables in other circuit if the program does not support schema.table address

How to load tables in other circuit if the program does not support the address in a type schema.table
Is user1 for connection and user2  as the circuit. user2  also has no rights for connection. It has been intentionally blocked for safety. Now it is necessary to load on a constant basis new tables from a name user1 in the circuit user2. How it to make? From basis?

2

Re: How to load tables in other circuit if the program does not support schema.table address

Synonym create

3

Re: How to load tables in other circuit if the program does not support schema.table address

Synonym How to create  to the future tables? Or I that did not understand that

4

Re: How to load tables in other circuit if the program does not support schema.table address

bkolubenka;
That is understood under to "load"
imp/impdp?
If imp/impdp that to read about fromuser touser / REMAP_SCHEMA
If something other - that explain more in detail what exactly.

5

Re: How to load tables in other circuit if the program does not support schema.table address

Kind  - Eh;
User User1 should create or load transparently tables in the circuit user2 through a program.

6

Re: How to load tables in other circuit if the program does not support schema.table address

bkolubenka;
alter session set current_schema =?

7

Re: How to load tables in other circuit if the program does not support schema.table address

Kind  - Eh;
Yes this variant to be pleasant to me. And it is possible to fix it for the user user1 on a constant basis. I use user1 only for .

8

Re: How to load tables in other circuit if the program does not support schema.table address

Be shorter all dances should from basis. Aside programs of anything cannot be changed. And how to save it for the user eternally instead of for each session?

9

Re: How to load tables in other circuit if the program does not support schema.table address

proxy user
?

10

Re: How to load tables in other circuit if the program does not support schema.table address

https://asktom.oracle.com/pls/apex/f?p= … 5905259251

11

Re: How to load tables in other circuit if the program does not support schema.table address

https://asktom.oracle.com/pls/asktom/f? … 9994929803