DBA*Robot automatic logins
C:\Project\DbaRobot\demo>dbarobot -v dbarobot@prod democreate
Password:
Opening democreate.sql
============================================================================
create schema demo1
============================================================================
connect to dbarobot@prod
create user demo1 identified by values 'DD9FD1922A0AFC29' .. ok
grant create session to demo1 .. ok
grant create table to demo1 .. ok
grant create procedure to demo1 .. ok
alter user demo1 default tablespace users quota unlimited on user .. ok
connect to demo1@prod
create table t1 (f1 integer, f2 integer) .. ok
create or replace package pkg1 as procedure p1; end; .. ok
create or replace package body pkg1 as procedure p1 is v integer; .. ok
Closing democreate.sql
Done.
|
|
Normal usage of SQL*Plus
C:\Project\DbaRobot\demo>sqlplus dbarobot@prod @democreate
SQL*Plus: Release 9.0.1.0.1 - Production on Wed Sep 28 10:21:31 2005
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle9i Release 9.0.1.1.1 - Production
JServer Release 9.0.1.1.1 - Production
============================================================================
create schema demo1
============================================================================
Enter value for dbarobot_pwd: dbapwd
Enter value for ora_sid: prod
Connected.
User created.
Grant succeeded.
Grant succeeded.
Grant succeeded.
User altered.
Enter value for demo1_pwd: demo1
Connected.
Table created.
Package created.
Package body created.
SQL>
|
