Crystal/Oracle: Changing underlying schema name without rewriting report

joak used Ask the Experts™
In Oracle, we have a single database with multiple schema names.  I have written Crystal reports (versions 7, 8.5) for one schema, but don't know how to copy them over to another schema without logging into that schema and starting from scratch.  It appears that the schema name is implicit, based on how I log in to Crystal. Am I missing something?  I know how to change the server name, but this is more subtle than that.  Thanks for your help.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I have worked with Oracle but do not know what you mean by 'schema'?

Are you talking about shifting a report between databases?
Hi Joak.

I understand that you work on one only instance, and you have diverse outlines in that same instance.

If you want to execute reports in several outlines of the same instance, you should revise the users of DB and their permissions, since they are the users with those that carry out the connection and these users are assembled to the schemes.

I understand that the schemes are the skeleton of the instance, and that each outline has assembled to their boards, views and others objects, and the users that are assigned to that only outline they could see the objects of the scheme.
This question has been classified abandoned. I will make a recommendation to the moderators on its resolution in a week or two. I appreciate any comments that would help me to make a recommendation.

Unless it is clear to me that the question has been answered I will recommend delete. It is possible that a Grade less than A will be given if no expert makes a case for an A grade. It is assumed that any participant not responding to this request is no longer interested in its final disposition.

If the user does not know how to close the question, the options are here:

Pat K
EE Cleanup Volunteer

Give the points to mr_citron - I guess he answered it.

No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: mr_citron {http:#7484108}

Please leave any comments here within the next seven days.

EE Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial