Oracle Unleashed- P6: When I first started using Oracle many years ago, it was possible to know the database and the tools available. With the rash of recent releases of different options for the database and the spate of new tools, only people who wear their underpants over their trousers will be able to know everything there is to know about the Oracle products. | Enter table name or . if done dept Enter table name or . if done . The last example is from full database mode. Import entire export file yes no yes Y User Mode The user method of Import enables you to import tables that belong to a specific user. This can also be combined with the table mode to import specific tables from a specific schema. This is important because Import attempts to create the tables in the current schema s default tablespace if the schema specified in the export file does not exist. This can work to your advantage if you need to move tables from one schema to another. Table Mode You usually use table mode to import a table or a list of tables rather than all tables in the export file. If a user has access to other schema he can import tables from other schema by qualifying with the schema name. The default is to import all tables in the schema of the user doing the import. Full Database Mode The full database option of Import does not quite work the same way as the full database option of Export. If you specify the full database option in Export the entire database is exported and to import the entire file you must have the role IMP_FULL_DATABASE assigned to you. If the export file is a user export or table export the entire export file is imported whatever is in it and you do not need to have the role IMP_FULL_DATABASE assigned to you. Interactive Versus Command Line Both Import and Export can operate in command-line mode and in interactive mode. Both modes have their advantages but Oracle recommends that you use the command-line mode with a parameter file. The two modes are outlined in this section. I m sure you will find good reasons for using both in your own situation. Interactive Method The interactive method is an easy way to import data from export files but you do not have all the options of the parameter or command-line method. For example you cannot create an index file. The interactive prompts might change depending on the response
