Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Interbase to Oracle
I don't think you could create tables without the user name (schema) because
all objects must be in a schema. But maybe you could get away with it by
using synonyms. You could have a public synonym abc for your table user.abc,
for instance. Your application could then refer to "abc" and it should
actually mean "user.abc". Of course, I don't know delphi.
Paul Cardwell <PCardwell_at_RTDQuality.com> wrote in message
news:3c1R3.8718$G6.778057_at_news0.telusplanet.net...
> 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.
>
>
>
Received on Tue Oct 26 1999 - 04:59:57 CDT