nothing, I didn't get any table, view, etc.
alter tablespace +name+ add datafile '+/path to old tablespase+'
I got error message about wrong database id and can't open database.
restore controlfile from '+path to backup controlfile+'
Krzysztof Szymaniak wrote:Don't create new database/tablespace !
please let me know where I can find good solution for restore and recover database in situation when I have reinstalled all system with database.
From "old" database I have datafiles(tablespace), backup files, backup controlfile, etc. In "new" database I create new tablespace, the name of "new" database is the same as "old"