Do you know if is posible generate the singletask commands to export an import tools for oracle 9.2.0.2 on HP-UX 11.11 ?
What is the procedure?
Note: If you are the author of this question and wish to assign points to any of the answers, please login first.For more information on assigning points ,click
here
You can do the export and import of tables or the complete schema or full database through a script.
Atttached is the script that does a simple export from a target database and then importes into the target database.
you can export only tables by specifying tables=owner.table_name in the exp parameters list, or for a complete schema export specify owner=schema_name or for full database specify full=y.
And likewise in the import parameters list specify the same for table specify table=table_name (you do not qualify the owner with the table_name as you specify fromuser= and touser= in an import) and for full database specify full=y.
You can use the other parameters options in the exp and imp utilities (check for more by typing exp HLEP=Y and imp HELP=Y) and choose the options appropriate for your requirement.
In Oracle Server - Enterprise Edition 9i, Single-task linking and non-deferred linking are not supported You will experience the following errors when linking executables in single-task mode for example âld: I/O error, file "$ORACLE_HOME/rdbms/lib/kpufpd.o": No such file or directory unable to create single-task executables (expst,impst,sqlldrst)
The fix for this is to use two-task (normally) linked executables.
Do not pass following targets to the make utlility: singletask, expst, impst, sqlldrst I.e. use make -f ins_rdbms.mk iexp iimp isqlldr
instead of make -f ins_rdbms.mk expst impst sqlldrst make -f ins_rdbms.mk singletask
Printable version
