Import .gz to Oracle Database XE 10g
809733Nov 1 2010 — edited Nov 2 2010Hi,
I'm trying to import a previously exported oracle DB to a newly installed Oracle Database XE 10g. After reading the documentation and a lot of forum posts I couldn't find what I was doing wrong.
Unfortunately, I don't have any information about the origin and method used to export the file I have. All I can tell you is that it has .gz extension.
I tried using the following statement:
imp SYSTEM/secret SCHEMAS=schema1 DIRECTORY=dmpdir DUMPFILE=backup.gz
REMAP_SCHEMA=schema1:schema2 EXCLUDE=constraint, ref_constraint, index
TABLE_EXISTS_ACTION=replace LOGFILE=impschema.log
I try running this from the command line on the web interface of Oracle XE but I get: "ORA-00900: invalid SQL statement". I'm not even sure if I should be running it from the command line.
I just started using Oracle Database today for the first time in my life so I'm sorry if I sound like a total noob.
I'm running the database on Windows XP
Can someone help me please? I have no idea what to do.
Thanks