Export and Import Data Records in Small Numbers Situation

Export data

As you use one user login ORACLE and use "exp" tool to export database's records. It will only export the records of the tables of yours(such as scotter) to a file defaultly.

Import data

Use the "Imp" tool to import the exported file to the database. Change the current directory context to the exported file's path and type command "imp". Then choose the right one as it promotes(mostly choose the default one) and at the last one choose "yes" to import all the data in the exported file to the database.You should know konw that it will create tables for you defaultly when you do it.So maybe you will need to drop the tables first.