Re: 8.1.7 Backup and Restore

In article <ulabbnk9iq9c7d_at_corp.supernews.com>, "Chuck" says...
>
>Prior to moving to a new server, we did an export of all of the databases.
>This worked fine. When importing on the new server, we lost all the user
>defined schemas that were created for our application as well as schemas for
>each user that had an ID on the system. I also lost one tablespace that all
>user's were associated to as their default. I ended up re-creating the
>databases and then creating all of the database tables, views, etc. from
>ERWIN. Then we ran some load scripts to load up the initial data. Lucklily
>we just went to a production application so we didn't lose much.
>
>What did we do wrong? I thought if you do an export then the tablespaces,
>schemas, etc. should be importing just as they were exported.
>
>Can anyone give advice on fixing this problem so if I ever have to import
>from an export again, eveything will be restored just as it was backed up.
>
>Thank you.
>
>Chuck
>
>

what do you mean by "lost" -- was there an error message, did import tell you "I'm importing this user"

Imp won't "lose" things -- you'll need to give us a tad more info on what you did and what you observed (error messages, informational messages, etc)

--
Thomas Kyte (tkyte_at_oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp