Hello, i have an export file in /exports/full_20010729.dmp and I would like to import this into a instance called prdw, this comes about form a problem that I have had ealier this month, my table became lock with an in-doubt transation and we tried everything that you guys suggested but still no luck. so I would like to put the table back the way it was before this happened.
I tried to import the table but it says unable to create intial extent for segment in table space dta_rel_erwkshft. I renamed the old table, but do I have to drop it in order to get rid of the old table space? Is the problem that the same table space still exsists? what would happened if I were to restore the file to which the table space points to, would that restore the table to way it was before, would that get rid of the lock on my rows?
You may want to truncate that table before inserting data into it, that is what I do. It is also a good idea to back up the table before you truncate it. It could also be that you have
ignore= n, come to think of it, this is probably your problem.
try setting it to =Y
All I can think of is your tablespace is full so when you took and export it must have been compress=y so when you are importing it back it is unable to allocate a large extent in the tablespace. Try adding a datafile to the tablespace.
Originally posted by spower unable to create inital segment for tablespace....
You are getting this error because there is no extent large enough in your target tablespace that will hold the INITIAL extent. You could either add more space to your tablespace or pre-create your table and import with ignore=y.
To pre-create your table, add the indexfile option to the exp command:
exp system/yourpw@yourdb file=yourexpfile.dmp indexfile=yourdb.sql tables=...
Then, in yourdb.sql will be a bunch of DDL that you can edit and pre-create your tables.