Import an Oracle dump to oracle XE in 3 steps:
- Create a directory to contain a new tablespace
- Create a dedicated tablespace and user that reflects the name of the ones used to export
- Import the dump into this new tablespace
Detailled instructions
————————————————
Create a directory for Data (tablespace)
———————————————–
mkdir C:\myDataFiles |
———————————————————
Create a TAB_CS tablespace
Use exactly this name as it will be requested for import
Connect to XE as System user (use SQL developper for instance)
and run the following script and COMMIT !
———————————————————–
CREATE TABLESPACE TAB_CS DATAFILE 'C:\myDataFiles\TAB_CS.ora' SIZE 10M AUTOEXTEND ON NEXT 5M; CREATE USER MyUser IDENTIFIED BY MyPass DEFAULT TABLESPACE TAB_CS TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK QUOTA UNLIMITED ON TAB_CS; GRANT CONNECT TO MyUser; GRANT RESOURCE TO MyUser; GRANT DBA TO MyUser; |
—————-
Import the DUMP
—————-
Copy the dump file to c:\TheDumpFIle.dump
Open windows command prompt (Start/Run/cmd) and run:
C:\oraclexe\app\oracle\product\10.2.0\server\BIN\imp.exe M260/M260 file=TheDumpFIle.dump full=yes |
Import should run without any warning
Verify that everything is OK ussing an Oracle client connect as MyUservia SQL developper and check tables