Oracle export and import utilities - Explain how to import tables to a
different tablespace posted by
Babu Kunwar
Explain how to import tables to a different tablespace
As EXPORT/IMPORT rules that Oracle offers import will be done in the same form
as the data was exported. We can do this through INDEXFILE. First we need to
edit this file. Change the tablespace and then force run this INDEXFILE against
database this will create the required tables in the appropriate tablespaces
then import the table with the IGNORE=Y option. Next change the default
tablespace and make call to user from where the data was exported. This forcing
causes the import utility to import tables to a different tablespace.
More links
What is SQL*Plus? Explain its features
Explain how to use the SQL*Plus utility.
What are the basic SQL*Plus commands?
What is AFIEDT.BUF?.............
|
