"Igor Damiani" <igor_at_igordamiani.it> wrote in message
news:bljukq$d4upr$1_at_ID-134521.news.uni-berlin.de...
> Hello everybody....
>
> Using MS-SQL Server I can write this simple T-SQL command:
>
> use "db_name"
>
> Can I obtain same result using Oracle 8.1 database server?
> I need to login with unique username and password, and change different
> database using SQL command
> to run ALTER TABLE and other SQL script......
>
> Can you help me, please?
> Tks a lot!!!
> good coding!!!
You need to do some reading. You need either to reconnect to the instance as
the owner of the tables each time, or specify the owner of the table in your
script. since the term "database" means different things in the oracle and
sqlserver worlds.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Fri Oct 03 2003 - 09:15:31 CDT
