Posts by dan420

One problem is the files produced by imp and exp are not backwardly compatible. That is if you use the 10g version of exp to create a dump file, you can't use the 9i version of imp to import the data.

In this case you need to use the 9i version of exp, connected to the 10g database, then use the 9i version of imp to import the data.

Oracle does not accepts the "-" sign for the columns. If you want your column to be called e-mail then make it "e-mail".
And your foreign key declaration is not good,