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
