ياشباب ممكن حد يساعدني في انشاء قاعدة البيانات يدويا من البداية في oracle 10g
,windows XP

انشاء TABLE SPACE THEN DATAFILE

CREATE BIGFILE TABLESPACE "SLRY_TABLE_SPACE" DATAFILE 'F:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SLRY_DATAFILE' SIZE 100M REUSE AUTOEXTEND ON NEXT 10K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO 
BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'SLRY_TABLE_SPACE'); END;


انشاء مستخدم مع صلاحيات الاتصال
CREATE USER "SLRY_ADMIN" PROFILE "DEFAULT" IDENTIFIED BY "*******" DEFAULT TABLESPACE "SLRY_TABLE_SPACE" TEMPORARY TABLESPACE "SLRY_TABLE_SPACE" ACCOUNT UNLOCK
GRANT "CONNECT" TO "SLRY_ADMIN"

انشاء مستخدم مع صلاحيات الاتصال ومدير قواعد البيانات
CREATE USER "SLRY_ADMIN" PROFILE "DEFAULT" IDENTIFIED BY "*******" DEFAULT TABLESPACE "SLRY_TABLE_SPACE" TEMPORARY TABLESPACE "SLRY_TABLE_SPACE" ACCOUNT UNLOCK
GRANT "CONNECT" TO "SLRY_ADMIN" WITH ADMIN OPTION
GRANT "DBA" TO "SLRY_ADMIN" WITH ADMIN OPTION
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
اعطاء صلاحيات OBJECT

BEGIN DBMS_WM.GrantSystemPriv('ACCESS_ANY_WORKSPACE', 'SLRY_ADMIN', 'NO');
END; 

GRANT ADMINISTER ANY SQL TUNING SET TO "SLRY_ADMIN"
GRANT ADMINISTER DATABASE TRIGGER TO "SLRY_ADMIN"
BEGIN dbms_resource_manager_privs.grant_system_privilege(privilege_name=>'ADMINISTER_RESOURCE_MANAGER', grantee_name=>'SLRY_ADMIN', admin_option=>FALSE); 
END; 

GRANT ADMINISTER SQL TUNING SET TO "SLRY_ADMIN"
GRANT ADVISOR TO "SLRY_ADMIN"
GRANT ALTER ANY CLUSTER TO "SLRY_ADMIN"
GRANT ALTER ANY DIMENSION TO "SLRY_ADMIN"
GRANT ALTER ANY EVALUATION CONTEXT TO "SLRY_ADMIN"
GRANT ALTER ANY INDEX TO "SLRY_ADMIN"
GRANT ALTER ANY INDEXTYPE TO "SLRY_ADMIN"
GRANT ALTER ANY LIBRARY TO "SLRY_ADMIN"
GRANT ALTER ANY MATERIALIZED VIEW TO "SLRY_ADMIN"
GRANT ALTER ANY OUTLINE TO "SLRY_ADMIN"
GRANT ALTER ANY PROCEDURE TO "SLRY_ADMIN"
GRANT ALTER ANY ROLE TO "SLRY_ADMIN"
GRANT ALTER ANY RULE TO "SLRY_ADMIN"
GRANT ALTER ANY RULE SET TO "SLRY_ADMIN"
GRANT ALTER ANY SEQUENCE TO "SLRY_ADMIN"
GRANT ALTER ANY SQL PROFILE TO "SLRY_ADMIN"
GRANT ALTER ANY TABLE TO "SLRY_ADMIN"
GRANT ALTER ANY TRIGGER TO "SLRY_ADMIN"
GRANT ALTER ANY TYPE TO "SLRY_ADMIN"
GRANT ALTER DATABASE TO "SLRY_ADMIN"
GRANT ALTER PROFILE TO "SLRY_ADMIN"
GRANT ALTER RESOURCE COST TO "SLRY_ADMIN"
GRANT ALTER ROLLBACK SEGMENT TO "SLRY_ADMIN"
GRANT ALTER SESSION TO "SLRY_ADMIN"
GRANT ALTER SYSTEM TO "SLRY_ADMIN"
GRANT ALTER TABLESPACE TO "SLRY_ADMIN"
GRANT ALTER USER TO "SLRY_ADMIN"
GRANT ANALYZE ANY TO "SLRY_ADMIN"
GRANT ANALYZE ANY DICTIONARY TO "SLRY_ADMIN"
GRANT AUDIT ANY TO "SLRY_ADMIN"
GRANT AUDIT SYSTEM TO "SLRY_ADMIN"
GRANT BACKUP ANY TABLE TO "SLRY_ADMIN"
GRANT BECOME USER TO "SLRY_ADMIN"
GRANT COMMENT ANY TABLE TO "SLRY_ADMIN"
GRANT CREATE ANY CLUSTER TO "SLRY_ADMIN"
GRANT CREATE ANY CONTEXT TO "SLRY_ADMIN"
GRANT CREATE ANY DIMENSION TO "SLRY_ADMIN"
GRANT CREATE ANY DIRECTORY TO "SLRY_ADMIN"
GRANT CREATE ANY EVALUATION CONTEXT TO "SLRY_ADMIN"
GRANT CREATE ANY INDEX TO "SLRY_ADMIN"
GRANT CREATE ANY INDEXTYPE TO "SLRY_ADMIN"
GRANT CREATE ANY JOB TO "SLRY_ADMIN"
GRANT CREATE ANY LIBRARY TO "SLRY_ADMIN"
GRANT CREATE ANY MATERIALIZED VIEW TO "SLRY_ADMIN"
GRANT CREATE ANY OPERATOR TO "SLRY_ADMIN"
GRANT CREATE ANY OUTLINE TO "SLRY_ADMIN"
GRANT CREATE ANY PROCEDURE TO "SLRY_ADMIN"
GRANT CREATE ANY RULE TO "SLRY_ADMIN"
GRANT CREATE ANY RULE SET TO "SLRY_ADMIN"
GRANT CREATE ANY SEQUENCE TO "SLRY_ADMIN"
GRANT CREATE ANY SQL PROFILE TO "SLRY_ADMIN"
GRANT CREATE ANY SYNONYM TO "SLRY_ADMIN"
GRANT CREATE ANY TABLE TO "SLRY_ADMIN"
GRANT CREATE ANY TRIGGER TO "SLRY_ADMIN"
GRANT CREATE ANY TYPE TO "SLRY_ADMIN"
GRANT CREATE ANY VIEW TO "SLRY_ADMIN"
GRANT CREATE CLUSTER TO "SLRY_ADMIN"
GRANT CREATE DATABASE LINK TO "SLRY_ADMIN"
GRANT CREATE DIMENSION TO "SLRY_ADMIN"
GRANT CREATE EVALUATION CONTEXT TO "SLRY_ADMIN"
GRANT CREATE INDEXTYPE TO "SLRY_ADMIN"
GRANT CREATE JOB TO "SLRY_ADMIN"
GRANT CREATE LIBRARY TO "SLRY_ADMIN"
GRANT CREATE MATERIALIZED VIEW TO "SLRY_ADMIN"
GRANT CREATE OPERATOR TO "SLRY_ADMIN"
GRANT CREATE PROCEDURE TO "SLRY_ADMIN"
GRANT CREATE PROFILE TO "SLRY_ADMIN"
GRANT CREATE PUBLIC DATABASE LINK TO "SLRY_ADMIN"
GRANT CREATE PUBLIC SYNONYM TO "SLRY_ADMIN"
GRANT CREATE ROLE TO "SLRY_ADMIN"
GRANT CREATE ROLLBACK SEGMENT TO "SLRY_ADMIN"
GRANT CREATE RULE TO "SLRY_ADMIN"
GRANT CREATE RULE SET TO "SLRY_ADMIN"
GRANT CREATE SEQUENCE TO "SLRY_ADMIN"
GRANT CREATE SESSION TO "SLRY_ADMIN"
GRANT CREATE SYNONYM TO "SLRY_ADMIN"
GRANT CREATE TABLE TO "SLRY_ADMIN"
GRANT CREATE TABLESPACE TO "SLRY_ADMIN"
GRANT CREATE TRIGGER TO "SLRY_ADMIN"
GRANT CREATE TYPE TO "SLRY_ADMIN"
GRANT CREATE USER TO "SLRY_ADMIN"
GRANT CREATE VIEW TO "SLRY_ADMIN"
BEGIN DBMS_WM.GrantSystemPriv('CREATE_ANY_WORKSPACE', 'SLRY_ADMIN', 'NO');
END; 

GRANT DEBUG ANY PROCEDURE TO "SLRY_ADMIN"
GRANT DEBUG CONNECT SESSION TO "SLRY_ADMIN"
GRANT DELETE ANY TABLE TO "SLRY_ADMIN"
BEGIN dbms_aqadm.grant_system_privilege(privilege=>'DEQUEUE_ANY', grantee=>'SLRY_ADMIN', admin_option=>FALSE); 
COMMIT; 
END; 

GRANT DROP ANY CLUSTER TO "SLRY_ADMIN"
GRANT DROP ANY CONTEXT TO "SLRY_ADMIN"
GRANT DROP ANY DIMENSION TO "SLRY_ADMIN"
GRANT DROP ANY DIRECTORY TO "SLRY_ADMIN"
GRANT DROP ANY EVALUATION CONTEXT TO "SLRY_ADMIN"
GRANT DROP ANY INDEX TO "SLRY_ADMIN"
GRANT DROP ANY INDEXTYPE TO "SLRY_ADMIN"
GRANT DROP ANY LIBRARY TO "SLRY_ADMIN"
GRANT DROP ANY MATERIALIZED VIEW TO "SLRY_ADMIN"
GRANT DROP ANY OPERATOR TO "SLRY_ADMIN"
GRANT DROP ANY OUTLINE TO "SLRY_ADMIN"
GRANT DROP ANY PROCEDURE TO "SLRY_ADMIN"
GRANT DROP ANY ROLE TO "SLRY_ADMIN"
GRANT DROP ANY RULE TO "SLRY_ADMIN"
GRANT DROP ANY RULE SET TO "SLRY_ADMIN"
GRANT DROP ANY SEQUENCE TO "SLRY_ADMIN"
GRANT DROP ANY SQL PROFILE TO "SLRY_ADMIN"
GRANT DROP ANY SYNONYM TO "SLRY_ADMIN"
GRANT DROP ANY TABLE TO "SLRY_ADMIN"
GRANT DROP ANY TRIGGER TO "SLRY_ADMIN"
GRANT DROP ANY TYPE TO "SLRY_ADMIN"
GRANT DROP ANY VIEW TO "SLRY_ADMIN"
GRANT DROP PROFILE TO "SLRY_ADMIN"
GRANT DROP PUBLIC DATABASE LINK TO "SLRY_ADMIN"
GRANT DROP PUBLIC SYNONYM TO "SLRY_ADMIN"
GRANT DROP ROLLBACK SEGMENT TO "SLRY_ADMIN"
GRANT DROP TABLESPACE TO "SLRY_ADMIN"
GRANT DROP USER TO "SLRY_ADMIN"
BEGIN dbms_aqadm.grant_system_privilege(privilege=>'ENQUEUE_ANY', grantee=>'SLRY_ADMIN', admin_option=>FALSE); 
COMMIT; 
END; 

GRANT EXECUTE ANY CLASS TO "SLRY_ADMIN"
GRANT EXECUTE ANY EVALUATION CONTEXT TO "SLRY_ADMIN"
GRANT EXECUTE ANY INDEXTYPE TO "SLRY_ADMIN"
GRANT EXECUTE ANY LIBRARY TO "SLRY_ADMIN"
GRANT EXECUTE ANY OPERATOR TO "SLRY_ADMIN"
GRANT EXECUTE ANY PROCEDURE TO "SLRY_ADMIN"
GRANT EXECUTE ANY PROGRAM TO "SLRY_ADMIN"
GRANT EXECUTE ANY RULE TO "SLRY_ADMIN"
GRANT EXECUTE ANY RULE SET TO "SLRY_ADMIN"
GRANT EXECUTE ANY TYPE TO "SLRY_ADMIN"
GRANT EXPORT FULL DATABASE TO "SLRY_ADMIN"
GRANT FLASHBACK ANY TABLE TO "SLRY_ADMIN"
GRANT FORCE ANY TRANSACTION TO "SLRY_ADMIN"
GRANT FORCE TRANSACTION TO "SLRY_ADMIN"
GRANT FREEZE_ANY_WORKSPACE TO "SLRY_ADMIN"
GRANT GLOBAL QUERY REWRITE TO "SLRY_ADMIN"
GRANT GRANT ANY OBJECT PRIVILEGE TO "SLRY_ADMIN"
GRANT GRANT ANY PRIVILEGE TO "SLRY_ADMIN"
GRANT GRANT ANY ROLE TO "SLRY_ADMIN"
GRANT IMPORT FULL DATABASE TO "SLRY_ADMIN"
GRANT INSERT ANY TABLE TO "SLRY_ADMIN"
GRANT LOCK ANY TABLE TO "SLRY_ADMIN"
BEGIN dbms_aqadm.grant_system_privilege(privilege=>'MANAGE_ANY', grantee=>'SLRY_ADMIN', admin_option=>FALSE); 
COMMIT; 
END; 

GRANT MANAGE SCHEDULER TO "SLRY_ADMIN"
GRANT MANAGE TABLESPACE TO "SLRY_ADMIN"
BEGIN DBMS_WM.GrantSystemPriv('MERGE_ANY_WORKSPACE', 'SLRY_ADMIN', 'NO');
END; 

GRANT ON COMMIT REFRESH TO "SLRY_ADMIN"
GRANT QUERY REWRITE TO "SLRY_ADMIN"
BEGIN DBMS_WM.GrantSystemPriv('REMOVE_ANY_WORKSPACE', 'SLRY_ADMIN', 'NO');
END; 

GRANT RESTRICTED SESSION TO "SLRY_ADMIN"
GRANT RESUMABLE TO "SLRY_ADMIN"
BEGIN DBMS_WM.GrantSystemPriv('ROLLBACK_ANY_WORKSPACE', 'SLRY_ADMIN', 'NO');
END; 

GRANT SELECT ANY DICTIONARY TO "SLRY_ADMIN"
GRANT SELECT ANY SEQUENCE TO "SLRY_ADMIN"
GRANT SELECT ANY TABLE TO "SLRY_ADMIN"
GRANT SELECT ANY TRANSACTION TO "SLRY_ADMIN"
GRANT UNDER ANY TABLE TO "SLRY_ADMIN"
GRANT UNDER ANY TYPE TO "SLRY_ADMIN"
GRANT UNDER ANY VIEW TO "SLRY_ADMIN"
GRANT UNLIMITED TABLESPACE TO "SLRY_ADMIN"
GRANT UPDATE ANY TABLE TO "SLRY_ADMIN"


CREATE SEQUENCE "SLRY_ADMIN"."NO_SEQ" NOCYCLE ORDER CACHE 20 NOMAXVALUE MINVALUE 1 INCREMENT BY 1 START WITH 1

ومرفق مذكرات dba
يمكن استعمالها لانشاء ما تريد

dbA_COMMANDS.pdf