Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Migrating from Interbase to Oracle
After connecting to Oracle issue a statement:
ALTER SESSION SET CURRENT_SCHEMA=<name of the owner of all tables and other
objects>
Thomas Olszewicki
ThomasO_at_cpas.com
www.cpas.com
QuestionExchange <USENET_at_questionexchange.com> wrote in message
news:2458qx_at_questionexchange.com...
> Hello Paul,
> Just to you known that I have an application that run in
> Interbase and Oracle, and I don't need to prefix a table with
> your owner, the way ?
> Use SYNONYMS, this feature found to make possible to access any
> object of database as you was the owner.
> Perhaps your sys admin don't known about this, take a look in
> Oracle documentation, is very good about this topic.
> Hope this help,
> Jean
> > I have a substantial amount of code (Delphi) that I developed
> with
> > Interbase but I now need to go live into Oracle. The
> problem, Oracle
> > prefixes all the tables with the owner name...is there a way
> not to
> > have this prefix when making the tables? My sys admin says
> no.
> >
> > Paul Cardwell
> > PCardwell_at_RtdQuality.com
> >
> >
> >
>
> --
> This answer is courtesy of QuestionExchange.com
>
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=7090&cus_id=USE
NET&qtn_id=6265
Received on Fri Nov 12 1999 - 23:28:04 CST