Re: Full Export/Import

You can NOT edit a dump file. It's a binary file, so don't even think about it. You'll corrupt the file and make it totally unuseable. The create tablespace commands it contains would normally be applicable if you were reconstructing a database on an identically-configured machine (same O/S, same disk layouts and so forth).

In your case, you'll simply need to manually create all required tablespaces on the NT box before you attempt the import. When you then try to import tables, they will be created in the appropriate tablespace that *you* created with the identical name (and make sure the *tablespace* names really are identical, otherwise everything will end up in the SYSTEM tablespace (or your default tablespace -but neither is exactly what you want!).

If you are performing a full import, users and all appropriate privileges should be created automatically for you: the dump file has 'create user' statements in it, as I'm sure you've noticed. And it also have a raft of 'grant xxx to yyy' statements. That's assuming, though, that the export was done with grants included (a full export has them included by default).

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"S-marty" <monkey_at_ludo.aa> wrote in message
news:9td0s1$j3420_at_ns4.bih.net.ba...


>

> Howard J. Rogers wrote in message

> <3bf8cf4b$0$13483$afc38c87_at_news.optusnet.com.au>...

> >I'm confused.  What's wrong with exp system/manager file=blah.dmp full=y?

> >

> >Use the lower version of export to produce a 7.3-compatible dump file.

Use


> >the 9i version of import to read it and import into the higher version of

> >the database.  Import will be imp system/manager file=blah.dmp, too.

> >

> >(I think what Sybrand was trying subtly to suggest is that, on the face

of


> >things, there's nothing terribly subtle about your request: it's basic

> >export and import, because, by default, export does a full database

export,


> >and import does a full database import... so therefore, it seems that

what


> >you don't understand or know how to do is basically to use either utility

> at

> >all.  Which is not a crime, but his answer is understandable nontheless.)

> >

> >Regards

> >HJR

> >--

>

>

> Thanx Howard

>

> Could you tell me this.

>

> What's happend with tablespaces?

> Oracle 7.3 database is on SCO OpenServer 5.2, and Oracle 9i is on Win2000.

> In the export file (blah.dmp), there are commands for creating tablespaces

> e.g.( CREATE TABLESPACE "RBS" DATAFILE  '/disk4/blah/rbs01.dbf' SIZE

> 188743680 REUSE DEFAULT STORAGE....)

> Do I have to change the datafile name?

> What's happend with rollback segments, are they online immediatly after

> creations ?

> What's happend with users?

> What's happend with system's privileges and roles...

> ...

> ...

>

> Regards

>

>

>