Re: Sybase -> Oracle8 SQL

From: venkata terala <venkata_at_inetnow.net>
Date: 1998/02/18
Message-ID: <34eb6f1f.0@news.inetnow.net>#1/1

Anis,
Oracle and SQL Server (Sybase and MS SQL server) have very different architectures. You don't usually create as many databases in Oracle as you would in SQL Server. A tablespace in Oracle is probably the closest thing to a database in SQL Server.
In Oracle you usually create a schema (a user) and build all the objects required by one application in that users' schema. hope that helps
Venkat

Anis Bouagina wrote in message <34EB00AF.A46F1B66_at_ant.uni-hannover.de>...
>Hi,
>
>I need to create an Oracle8 database for use with Jmapi.
>This is an Example with Sybase via isql.
>Can you give me similar SQL statements with my Oracle8 database .
>
>Thanks,
>Anis
>
>The Sybase Code :
>
> 1> create database testdb
> 2> on userdb=20
> 3> log on userlog=10
> 4> WITH OVERRIDE
> 5> go
>
> 1> sp_dboption testdb, "trunc log chkpt", "true"
> 2> go
>
> 1> sp_addlogin user_1, passwd_1
> 2> go
>
> 1> use server_1
> 2> go
>
> 1> sp_changedbowner user_1
> 2> go
>
>***********************************************************
> Anis Bouajina
>
> Institut für Allgemeine Nachrichtentechnik
> Appelstrasse 9A
> 30167 Hannover
> Tel.:0511/762-2840
>
> mailto:boua_at_ant.uni-hannover.de
> http://www.stud.uni-hannover.de/~bouagina
>***********************************************************
>
>
Received on Wed Feb 18 1998 - 00:00:00 CST