So that means if you want to import
any dmp file into a newly created database, you need to know the
tablespaces used in the exported database.
Right ?
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:ago2fb$j1j$1_at_lust.ihug.co.nz...
> ftp the dump file to the Windows box, making sure its a binary transfer,
not
> an ASCII one.
>
> On the Windows box, use Database Configuration Assistant to create you a
new
> database with nothing much in it -really, you're just after a SYSTEM
> tablespace. Manually create your tablespaces -the same ones you had on the
> Unix machine. Keep the tablespace names exactly the same, but stick the
> datafiles wherever is appropriate on your Windows box.
>
> It's also easier if you pre-create all the Users you had on the Unix
> database, too. Make sure you give them quotas on the appropriate
> tablespaces, but don't bother with permissions. Import will do that for
you.
>
> Now run import, specifying FULL=Y.
>
> Bingo.
>
> HJR
>
>
> "cel" <papouasied_at_yahoo.com> wrote in message
> news:3d2f5d67$0$548$626a54ce_at_news.free.fr...
> > Let's say I made a full export (tables, tablespaces, stored procedures
> etc)
> > from a database, running with Unix.
> > Now I want to create a database from scratch and import that dmf file in
> it.
> > I want to do it with Windows, Oracle 9i. Maybe with the Database
> > Configuration
> > Assistant ????
> >
> > I am looking for advices or nice links with tutorials.
> > thanks in advance
> >
> >
>
>
Received on Sat Jul 13 2002 - 09:43:37 CDT
