Export and Import oracle dump script
Can someone provide methe oracle export and import script. I just recently exported a oracle database to dmp file which is in 9i.
Now i like to import it into Oracle8 using the import script.
Please help.
Now i like to import it into Oracle8 using the import script.
Please help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
No, it is not possible to change the names with Import. But with Oracle 9i, you have feature to rename a table. So, you can import normally and then issue a statement of Alter Table tablename Rename to .
HTH.
Regards,
Badri.
No, it is not possible to change the names with Import. But with Oracle 9i, you have feature to rename a table. So, you can import normally and then issue a statement of Alter Table tablename Rename to .
HTH.
Regards,
Badri.
Renaming a table has been around long before 9.
You cannot directly use import and change the table name. However, there is a trick that should work, if I remember it correctly. Create the table with the new name, then create a synonym with the old name pointing to the new name. When you import, be sure to specify ignore=y.
You cannot directly use import and change the table name. However, there is a trick that should work, if I remember it correctly. Create the table with the new name, then create a synonym with the old name pointing to the new name. When you import, be sure to specify ignore=y.
Hello,
I must disagree with swertner, because I have done and export/import from a higher level db into a lower level db in the past.....
In order to import a table into 8i that was exported from a 9i database, you must use the 8i export utility against the 9i database first, to create the dmp file. Just remember that you will be limited to the 8i export functionality.
I must disagree with swertner, because I have done and export/import from a higher level db into a lower level db in the past.....
In order to import a table into 8i that was exported from a 9i database, you must use the 8i export utility against the 9i database first, to create the dmp file. Just remember that you will be limited to the 8i export functionality.
Renaming syntax for a table is simply
rename oldtablename to newtablename;
rename oldtablename to newtablename;
To Jim144:
What you say is limited to export of objects that exist in 8i.
If you try to export with 8i objects that are new for 9i and unknown for 8i,
the export will fail.
Example is the new AL32UTF8 character set that is new for 9i.
So, cutting the edges, one not very happy day of your career
your transfer metodology will not work and you will need to
look for other methods to transfer objects - flat files, DDL's, etc.
What you say is limited to export of objects that exist in 8i.
If you try to export with 8i objects that are new for 9i and unknown for 8i,
the export will fail.
Example is the new AL32UTF8 character set that is new for 9i.
So, cutting the edges, one not very happy day of your career
your transfer metodology will not work and you will need to
look for other methods to transfer objects - flat files, DDL's, etc.
To Schwertner:
You stated "It is not possible to import downwards" . .... I was simply stating it is possible. I also said you were limited to the 8i functionality .......
8^ )
You stated "It is not possible to import downwards" . .... I was simply stating it is possible. I also said you were limited to the 8i functionality .......
8^ )
Yes, I understand your point!
I think the risk in such solution is too high.
Oracle is used for big organization and the DBA has to
be very conservative not to bring troubles.
As a rule 8i software works not good with 9i and higher versions.
I think the risk in such solution is too high.
Oracle is used for big organization and the DBA has to
be very conservative not to bring troubles.
As a rule 8i software works not good with 9i and higher versions.
You're right (?) I'll not answer anymore ..... can't compete with someone that HAS to be right at all costs ....... thats why i stopped 2 years ago ...
No, no, these are emotions only!
I respect your contribution here!
Please excuse me, seems this are cultural differences
and an unwanted misunderstanding.
Excuse me for my remarks!
There is no competion at all! Points are nothing! Believe me!
I am very happy to know that Oracle 8i software
works against 9i. E.g. I failed to run Forms 6i
against 9i DB because of AL32UTF8 problem
and was very disapointed at that time.
I am sure we all be very happy if you
post here.
I respect your contribution here!
Please excuse me, seems this are cultural differences
and an unwanted misunderstanding.
Excuse me for my remarks!
There is no competion at all! Points are nothing! Believe me!
I am very happy to know that Oracle 8i software
works against 9i. E.g. I failed to run Forms 6i
against 9i DB because of AL32UTF8 problem
and was very disapointed at that time.
I am sure we all be very happy if you
post here.
ASKER