Hello,

I'm trying to copy company from live system to development system and when running session 'Create tables from sequential dump' I'm getting error 1959 (ORA-959 means that tablespace does not exist, afaik, but I have created this tablespace just before importing data to development system and I have added it to ora_storage file). Does anyone know any solution to this ?

Thanks in advance.

hi ,

Check the path of your sequential dumps . Might be you are providing a wrong path .

Regards ,
NIraj

Evilsvk,

Can you compare names between Oracle Storage Managers Tablespace names and ttdba0140m000 <retrive> tablespace names?

Also please post associated ora messages and give what steps you followed earlier.

regards,

-Suhas

My mistake, the problem was in ora_storage file. I've defined tablespaces for company xxx below these lines:

*:*:T:group:yyyy:5:TABLESPACE DOESNOTEXIST STORAGE(INITIAL 32K NEXT 1M MAXEXTENTS unlimited PCTINCREASE 0 FREELISTS 3)
*:*:I:group:yyyy:5:TABLESPACE DOESNOTEXIST STORAGE(INITIAL 32K NEXT 1M MAXEXTENTS unlimited PCTINCREASE 0 FREELISTS 3)

so it was completely ignored and baan was trying to store data in tablespace DOESNOTEXIST, which literally does not exist :D