The procedure to upload schema to the Database

The procedure to upload a schema to the Database:

Create user :

SQL> conn system/password@ora10g

Connected.

SQL> create user s_nq_sched

  2  identified by password

  3  default tablespace users

  4  temporary tablespace temp

/

Grant the following to the User:

SQL> grant connect

  2  ,     create table

  3  ,     create view

  4  ,     create procedure

  5  to    s_nq_sched

/

Connect to the user and copy the schema:

SQL> conn s_nq_sched/password@ora10g

Connected.

SQL> @c:\SiebelAnalytics\Schema\SAJobs.Oracle.sql