Page Comparison

VA Data Import - Oracle

Please follow below steps if you are going to use Oracle Database 12cR2 or above only and not PostgreSQL.

1. Create VA User in Oracle
   Connect to DB via SQLPLUS or SQLDeveloper with sys or system user and execute below commands.

(for pluggable database change to the appropirate container first for example using Oracle 21XE: alter session set container = xepdb1)

SQL> alter session set "_ORACLE_SCRIPT"=true;
Result: Session altered.
SQL> create user USERNAME identified by PASSWORD;

Result: User created.
SQL> grant dba, connect, resource , create view to USERNAME;

Result: Grant succeeded.
SQL> alter user USERNAME default tablespace users;

Result: User altered.
SQL> conn USERNAME/PASSWORD

Result: Connected. SQL>exit

2. Import Data in DB User Schema (Assuming you extracted to "C:\Temp" the oracle dump will be
in "C:\Temp\VIENNA_Advantage_ERP_CRM_HTML5_4_6_3_Oracle\ViennaAdvantageHTML5_DB\vacommunity.DMP" )

Open command prompt in administrator mode and execute below command to import VA Data in DB user imp USERNAME/PASSWORD File=’DB-Dump-File-Path.dmp’ Full=Y

Note: Please change USERNAME & Password in above commands as per your requirement