EXP vs EXPDP
Hi,
Can someone shed some light on the following ? We are still using some 8 an 9 databases and do a daily full logical export using exp as additional backup.
Up till now I still use this for our 10g database. But recently we got some products from external partners using float and double datatypes in their columns.
Now from the documentation which I found around exporting data is that the old style exp client doesn't support these datatypes.
First is it safe to change these columns to numeric without any scale,precision ? Second and more important if we change to the new server based datapump expd what are the issues to expect ? As I found in the 10g documentation that the XMLType is not supported with the expdp datapump utility but supported by exp.
Can someone shed some light on the following ? We are still using some 8 an 9 databases and do a daily full logical export using exp as additional backup.
Up till now I still use this for our 10g database. But recently we got some products from external partners using float and double datatypes in their columns.
Now from the documentation which I found around exporting data is that the old style exp client doesn't support these datatypes.
First is it safe to change these columns to numeric without any scale,precision ? Second and more important if we change to the new server based datapump expd what are the issues to expect ? As I found in the 10g documentation that the XMLType is not supported with the expdp datapump utility but supported by exp.
0