From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server References: <39BACDDD.1B8E9FFB@at.siemens.de> <39BAD2C9.579150F5@yahoo.com> <39BAD542.99A96494@at.siemens.de> Subject: Re: import problem (URGENT!!!) Lines: 60 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Original-NNTP-Posting-Host: 203.134.7.130 Message-ID: <39bae091$1@news.iprimus.com.au> X-Original-Trace: 10 Sep 2000 12:14:57 +1100, 203.134.7.130 Date: Sun, 10 Sep 2000 12:16:16 +1000 NNTP-Posting-Host: 203.134.64.67 X-Trace: news0.optus.net.au 968548498 203.134.64.67 (Sun, 10 Sep 2000 12:14:58 EST) NNTP-Posting-Date: Sun, 10 Sep 2000 12:14:58 EST Organization: Another Optus Customer True. It should create the tablespaces for you. However the path and filenames of the data files associated with those tablespaces is hard-coded in the dump file -so import will need to be able to create those files in exactly the right place. So you'd best hope this is being done on a second box, with an identical disk/directory configuration. And import will need to have appropriate permissions to create files etc. If it's on the same box, I'd suggest you at least create your *own* tablespaces (named exactly as on the source database, or you'll get into trouble with where your imported objects end up), putting the datafiles wherever you deem appropriate. *Then* you can run a full import, with ignore=Y, and you should get all your tables and indexes etc back. On the other hand, the whole thing could just be because it has crashed horribly -maybe no memory. You could perhaps try shutting down your original database first, thereby at least freeing up the SGA-amount of memory, and seeing if that helps. Or you could be running into some other O/S problem, such as semaphores, number of processes and so on. Regards HJR -- -------------------------------------------------------------------------- Opinions expressed are my own, and not those of Oracle Corporation Oracle DBA Resources: http://www.geocities.com/howardjr2000 -------------------------------------------------------------------------- "Markus Korn" wrote in message news:39BAD542.99A96494@at.siemens.de... > it is a full import! > it creates the tablespaces, rbs, ..... > and then at the table system.def$_destination it stops but consumes > all cpu > > now i try to create my database from the backup and do another export > i hope this works > > > how wrote: > > > > Um, have you created the necessary tablespaces and users? > > > > Markus Korn wrote: > > > > > Hello > > > > > > i have done a full export (rdbms 8.1.5.0.0) and now i try to > > > import this file to a "empty" database > > > > > > but the import hangs (no error message/no message in alertfile,... > > > > > > last message of imp is table system.def$_destination > > > > > > please help me!!!