Re: problem with migration from Access to Oracle

Hi,

to create yout db use something like:

create database oracle

    logfile

		group 1 ('c:\ora_redo\wdblog1.ora',
			'f:\ora_redo\wdblog1.ora',
            		'e:\ora_redo\wdblog1.ora') size 500K reuse,
		group 2 ('c:\ora_redo\wdblog2.ora', 
			'f:\ora_redo\wdblog2.ora',
            		'e:\ora_redo\wdblog2.ora')size 500K reuse,
		group 3 ('c:\ora_redo\wdblog3.ora', 
			'f:\ora_redo\wdblog3.ora',
            		'e:\ora_redo\wdblog3.ora')size 500K reuse
    character set WE8ISO8859P1
	datafile 'd:\dbf\dbsystem.ora' size 600M reuse
	MAXLOGMEMBERS 4

create tablespace makler

    datafile 'd:\dbf\dbmakler.ora' size 1000M reuse     default storage (initial 4k next 4k pctincrease 10 minextents 1 maxextents 121);
create tablespace makler_idx

    datafile 'd:\dbf\dbindex.ora' size 700M reuse     default storage (initial 4k next 4k pctincrease 10 minextents 1 maxextents 121);
create tablespace rollback_data

    datafile 'd:\dbf\dbrollb.ora' size 100M reuse     default storage (initial 50k next 50k minextents 7 maxextents 121); create tablespace temporary_data

    datafile 'd:\dbf\dbtemp.ora' size 1000M reuse     default storage (initial 1M next 1M pctincrease 5 minextents 1 maxextents 121);

alter user system temporary tablespace temporary_data; alter user system default tablespace system;

create public rollback segment rb1 storage(initial 10M next 1M)   tablespace rollback_data;

alter rollback segment rb1 online;

alter rollback segment rb_temp offline;

create public rollback segment rb2 storage(initial 10M next 1M)   tablespace rollback_data;

alter rollback segment rb2 online;

Bepou wrote:
>
> Hello Everybody,
>
> I use "Oracle Migration Wizard for Microsoft Access" to tranfer
> databases from Access to Oracle (under Windows NT 4)
>
> The problem I have is that the Oracle database is created under
> the default directory (D:\orant\database), and I don't find how to
> specify another path. I have to transfer very large databases and I
> would like to create them on my D: hard disk ...
>
> Thanks in advance !
>
> Bernard-Pierre Panet
 

-- 
Regards

Matthias Gresz    :-)