oracle IMP command - import a database into a clean install
Posted on 2003-03-24
I am trying to import a datbase from a solaris export into my win 2k box.
i used the command:
imp system/manager file=CON0.exp log=import_CON0.log full=y ignore=y commit=y
and it failed to import and killed my user accounts. i believe the full=y is why this happened. so i did a format and ready to try again.
I need to know how to import this database succsessfully.
ideally keeping the existing user accounts etc BUT its the table structure and data that matters the most.