Oracle XE Connect in command line.

user command

sqlplus / as sysdba

enter for connect as sysdba

Oracle : Import Export Whole DB

Export
set NLS_LANG=English
exp userid=[oldusername]/[oldpassword]@[sid] grants=no file=[filename].dmp
Import
set NLS_LANG=English
imp [username]/[password] file=[filename].dmp  full=yes

*may u need to grant extra role for import
SQL> grant imp_full_database to [username];

Oracle : Create new user

1. Check all users.
Start SQLPlus
If u are administrator
type
sqlpus / as sysdba
for login as sysdba
your password is sys password
type
select * from all_users;
for check all users.

2. Create new Table Space for new user (Or use old one.)
create tablespace TableSapceName datafile '[path]'
size 32m autoextend on
next 32m maxsize 2048m extent management local;
your default path for Oracle 11g Express is
'c:\oraclexe\app\oracle\oradata\XE\TableSpaceName.dbf'
dbf file will create automatically

3. Create new user with default table space.
CREATE USER [Name] IDENTIFIED BY [pass]
DEFAULT TABLESPACE "TableSpaceName"
TEMPORARY TABLESPACE "TEMP";

4. Alter user to unlimited with this tablespace.
ALTER USER [username] QUOTA UNLIMITED ON [TablespaceName];
5. Grant user permission
GRANT create procedure, create session, create table,
create type, create view, create synonym, create trigger,
resource TO [username];

grant imp_full_database to [username];

feature not enabled: Bit-mapped indexes

About error from run sql statement when need to create database.

sql statement is export from Hora software DLL

to work around changed

CREATE BITMAP INDEX

to

CREATE INDEX

It will work fine.

(I used XE version in my Notebook but in server export script is Enterprise version)