Print Page | Close Window

Changing Oracle Schema Name in SQL Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2022 Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1856 Printed Date: 06 Apr 2025 at 7:34pm Topic: Changing Oracle Schema Name in SQL Posted By: Ghauri Subject: Changing Oracle Schema Name in SQL Date Posted: 10 Dec 2007 at 2:46am I created a report on Oracle Database using JDBC connection. I created on a schema say USER1. When I run report and See View SQL it show the query For Instance: SELECT TAB1.C1, TAB1.C2  FROM USER1.TAB1 Now I want this report to be run on another schema say USER2 that is structurally alike on the same database instance (SID),and Same Host. For this I tried the following tricks to change the SQL like below. SELECT TAB1.C1, TAB1.C2  FROM USER2.TAB1 1. I log off and again Log on with the USER2 username and its password. But when I View SQL its unaltered :-( 2. I created a new JDBC Connection and logged in with USER2, but when I View SQL its unaltered :-( :-@ How can I recompile/update/change the SQL schema alias???? Thanks in Advance ------------- Thanks & Regards, Ghauri

Print Page | Close Window