Another option I though of, if I were to do a reinstall of XE, and then data pump the info from the EE to XE? Would that work?That's the way to do it. And you could have saved the time, especially what you've invested in your step 5). ;)
Just wondering, if the DB files are about 1Gb, should my dump file be 157Mb?I don't know, that depends on the actual amount of data stored in your database.
to see how much space is actually used in your data files. Note that this doesn't necessarily mean that your dump has to have that size. There are a few aspects (like compression) that could cause a difference...
SELECT f.file_name, CEIL( f.bytes / 1024 / 1024 ) "SIZE_MB", CEIL( f.bytes / 1024 / 1024 ) - FLOOR( SUM( NVL( fs.bytes, 0 ) ) / 1024 / 1024 ) "USED_MB", FLOOR( SUM( NVL( fs.bytes, 0 ) ) / 1024 / 1024 ) "FREE_MB", CEIL( f.maxbytes / 1024 / 1024 ) "MAX_MB" FROM dba_free_space fs, dba_data_files f WHERE fs.file_id(+) = f.file_id GROUP BY f.file_name, f.bytes, f.maxbytes, f.blocks, f.maxblocks, f.autoextensible ORDER BY f.file_name;