Refer table from another schemaChanging the default schema of a userExport table without BLOB columnWhy does...
Python 3.7 UltimateBruteforcer
How to write a character overlapping another character
Why are energy weapons seen as more acceptable in children's shows than guns that fire bullets?
Suggestions on how to improve logo
Buying a "Used" Router
How to assess the susceptibility of a U.S. company to go bankrupt?
What is the Guild Die for?
Contribution form
Manager has noticed coworker's excessive breaks. Should I warn him?
Why did Shae (falsely) implicate Sansa?
Identical projects by students at two different colleges: still plagiarism?
How to write pow math?
Is it possible to detect 100% of SQLi with a simple regex?
Why does calling Python's 'magic method' not do type conversion like it would for the corresponding operator?
Is the following statement true, false, or can't be determined? Why?
What prevents people from lying about where they live in order to reduce state income taxes?
Who, if anyone, was the first astronaut to return to earth in a different vessel?
Copy the content of an environment
GPL - Is it required to post source code to the Public - when is a software released?
How can guns be countered by melee combat without raw-ability or exceptional explanations?
Why are recumbent bicycles and velomobiles illegal in UCI bicycle racing?
Coworker is trying to get me to sign his petition to run for office. How to decline politely?
Should corporate security training be tailored based on a users' job role?
Why do climate experts from the UN/IPCC rarely mention Grand Solar Minimum?
Refer table from another schema
Changing the default schema of a userExport table without BLOB columnWhy does “GRANT SELECT … TO Role;” not allow members of Role to SELECT?Export Data Pump skipped packages bodiespermissions for yet another “ORA-06512: table or view does not exist” scenarioUpdate data of one table from another with comparing columns have same initial stringscreating and populating table using pl/sqlSequence number shows a lower value after dump file importOracle 12c export stuck forever if any table has default sequencecreate a backup table with million records
I would like to refer to multiple tables in another schema without schema prefix or altering the session.
I have the below query -
Select * from schema1.app_table
There r multiple queries like these in packages which have schema prefix.
I have to export the tables to a different schema. I really don’t want to change the schema prefix in all the packages.
I tried synonyms and unfortunately the solution is not I am looking for.
Plz help.
oracle oracle-12c plsql
asked 2 hours ago
Surajkuamr ShindeSurajkuamr Shinde
1
New contributor
Surajkuamr Shinde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I would like to refer to multiple tables in another schema without schema prefix or altering the session.
I have the below query -
Select * from schema1.app_table
There r multiple queries like these in packages which have schema prefix.
I have to export the tables to a different schema. I really don’t want to change the schema prefix in all the packages.
I tried synonyms and unfortunately the solution is not I am looking for.
Plz help.
oracle oracle-12c plsql
asked 2 hours ago
Surajkuamr ShindeSurajkuamr Shinde
1
New contributor
Surajkuamr Shinde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Which scema was the Package created in? Is it Invoker's Rights or Definer's Rights?
– Michael Kutz
19 mins ago
The packages are in another scheme schema2. The tables are in a separate schema. The queries would be executed from the packages with invoker rights.
– Surajkuamr Shinde
12 mins ago
I think you need to explay WHY synonyms are not the solution you are looking for. Synonyms are the textbook solution to your question.
– EdStevens
9 mins ago
Adding synonyms needs code changes and I want to reduce the code changes.
– Surajkuamr Shinde
1 min ago
add a comment |
I would like to refer to multiple tables in another schema without schema prefix or altering the session.
I have the below query -
Select * from schema1.app_table
There r multiple queries like these in packages which have schema prefix.
I have to export the tables to a different schema. I really don’t want to change the schema prefix in all the packages.
I tried synonyms and unfortunately the solution is not I am looking for.
Plz help.
oracle oracle-12c plsql
asked 2 hours ago
Surajkuamr ShindeSurajkuamr Shinde
1
New contributor
Surajkuamr Shinde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I would like to refer to multiple tables in another schema without schema prefix or altering the session.
I have the below query -
Select * from schema1.app_table
There r multiple queries like these in packages which have schema prefix.
I have to export the tables to a different schema. I really don’t want to change the schema prefix in all the packages.
I tried synonyms and unfortunately the solution is not I am looking for.
Plz help.
oracle oracle-12c plsql
oracle oracle-12c plsql
asked 2 hours ago
Surajkuamr ShindeSurajkuamr Shinde
1
New contributor
Surajkuamr Shinde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 hours ago
Surajkuamr ShindeSurajkuamr Shinde
1
New contributor
Surajkuamr Shinde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 hours ago
Surajkuamr ShindeSurajkuamr Shinde
1
New contributor
Surajkuamr Shinde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 hours ago
Surajkuamr ShindeSurajkuamr Shinde
1
asked 2 hours ago
Surajkuamr ShindeSurajkuamr Shinde
1
1
New contributor
Surajkuamr Shinde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Surajkuamr Shinde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Surajkuamr Shinde is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Which scema was the Package created in? Is it Invoker's Rights or Definer's Rights?
– Michael Kutz
19 mins ago
The packages are in another scheme schema2. The tables are in a separate schema. The queries would be executed from the packages with invoker rights.
– Surajkuamr Shinde
12 mins ago
I think you need to explay WHY synonyms are not the solution you are looking for. Synonyms are the textbook solution to your question.
– EdStevens
9 mins ago
Adding synonyms needs code changes and I want to reduce the code changes.
– Surajkuamr Shinde
1 min ago
add a comment |
Which scema was the Package created in? Is it Invoker's Rights or Definer's Rights?
– Michael Kutz
19 mins ago
The packages are in another scheme schema2. The tables are in a separate schema. The queries would be executed from the packages with invoker rights.
– Surajkuamr Shinde
12 mins ago
I think you need to explay WHY synonyms are not the solution you are looking for. Synonyms are the textbook solution to your question.
– EdStevens
9 mins ago
Adding synonyms needs code changes and I want to reduce the code changes.
– Surajkuamr Shinde
1 min ago
Which scema was the Package created in? Is it Invoker's Rights or Definer's Rights?
– Michael Kutz
19 mins ago
Which scema was the Package created in? Is it Invoker's Rights or Definer's Rights?
– Michael Kutz
19 mins ago
The packages are in another scheme schema2. The tables are in a separate schema. The queries would be executed from the packages with invoker rights.
– Surajkuamr Shinde
12 mins ago
The packages are in another scheme schema2. The tables are in a separate schema. The queries would be executed from the packages with invoker rights.
– Surajkuamr Shinde
12 mins ago
I think you need to explay WHY synonyms are not the solution you are looking for. Synonyms are the textbook solution to your question.
– EdStevens
9 mins ago
I think you need to explay WHY synonyms are not the solution you are looking for. Synonyms are the textbook solution to your question.
– EdStevens
9 mins ago
Adding synonyms needs code changes and I want to reduce the code changes.
– Surajkuamr Shinde
1 min ago
Adding synonyms needs code changes and I want to reduce the code changes.
– Surajkuamr Shinde
1 min ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Surajkuamr Shinde is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230181%2frefer-table-from-another-schema%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Surajkuamr Shinde is a new contributor. Be nice, and check out our Code of Conduct.
Surajkuamr Shinde is a new contributor. Be nice, and check out our Code of Conduct.
Surajkuamr Shinde is a new contributor. Be nice, and check out our Code of Conduct.
Surajkuamr Shinde is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230181%2frefer-table-from-another-schema%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Which scema was the Package created in? Is it Invoker's Rights or Definer's Rights?
– Michael Kutz
19 mins ago
The packages are in another scheme schema2. The tables are in a separate schema. The queries would be executed from the packages with invoker rights.
– Surajkuamr Shinde
12 mins ago
I think you need to explay WHY synonyms are not the solution you are looking for. Synonyms are the textbook solution to your question.
– EdStevens
9 mins ago
Adding synonyms needs code changes and I want to reduce the code changes.
– Surajkuamr Shinde
1 min ago