API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 14th, 2016
221
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 45.77 KB | None | 0 0
raw download clone embed print report
  1. -- ALTER SYSTEM SET db_create_online_log_dest_2 = "+SUITE8" SCOPE=SPFILE;
  2.  
  3. ALTER SYSTEM SET cluster_database = FALSE SCOPE=SPFILE;
  4. ALTER SYSTEM SET open_cursors = 2048 SCOPE=SPFILE;
  5. ALTER SYSTEM SET session_cached_cursors = 2048 SCOPE=SPFILE;
  6. ALTER SYSTEM SET star_transformation_enabled = "TRUE" SCOPE=SPFILE;
  7. ALTER SYSTEM SET O7_DICTIONARY_ACCESSIBILITY = FALSE SCOPE=SPFILE;
  8. ALTER SYSTEM SET audit_file_dest = "c:\oracle\admin\v8\adump" SCOPE=SPFILE;
  9. ALTER SYSTEM SET background_dump_dest = "c:\oracle\admin\v8\bdump" SCOPE=SPFILE;
  10. ALTER SYSTEM SET core_dump_dest = "c:\oracle\admin\v8\cdump" SCOPE=SPFILE;
  11. ALTER SYSTEM SET db_unique_name = "v8" SCOPE=SPFILE;
  12. ALTER SYSTEM SET fast_start_mttr_target = 1800 SCOPE=SPFILE;
  13. ALTER SYSTEM SET instance_name = "v8" SCOPE=SPFILE;
  14. ALTER SYSTEM SET job_queue_processes = 16 SCOPE=SPFILE;
  15. -- ALTER SYSTEM SET local_listener = "LISTENER" SCOPE=SPFILE;
  16. ALTER SYSTEM SET log_archive_start = FALSE SCOPE=SPFILE;
  17. ALTER SYSTEM SET log_checkpoint_timeout = 0 SCOPE=SPFILE;
  18. ALTER SYSTEM SET max_dump_file_size = "4M" SCOPE=SPFILE;
  19. ALTER SYSTEM SET optimizer_index_cost_adj = 10 SCOPE=SPFILE;
  20. ALTER SYSTEM SET optimizer_mode = "FIRST_ROWS_100" SCOPE=SPFILE;
  21. ALTER SYSTEM SET pre_page_sga = FALSE SCOPE=SPFILE;
  22. ALTER SYSTEM SET recyclebin = "OFF" SCOPE=SPFILE;
  23. ALTER SYSTEM SET service_names = 'v8' SCOPE=SPFILE;
  24. ALTER SYSTEM SET statistics_level = "TYPICAL" SCOPE=SPFILE;
  25. ALTER SYSTEM SET timed_statistics = TRUE SCOPE=SPFILE;
  26. ALTER SYSTEM SET undo_retention = 1740 SCOPE=SPFILE;
  27. ALTER SYSTEM SET user_dump_dest = "c:\oracle\admin\v8\udump" SCOPE=SPFILE;
  28. ALTER SYSTEM SET utl_file_dir = "c:\oracle\10.2.0\database\database" SCOPE=SPFILE;
  29. ALTER SYSTEM SET workarea_size_policy = "AUTO" SCOPE=SPFILE;
  30.  
  31.  
  32. HOST mkdir d:\oracle\oradata\v8\flash_recovery_area\dpdump
  33. CREATE OR REPLACE DIRECTORY data_pump_dir AS 'd:\oracle\oradata\v8\flash_recovery_area\dpdump';
  34.  
  35. /*
  36. ALTER DATABASE ADD LOGFILE GROUP 1 ( '+SUITE8/v8/onlinelog/group_1.257.607532983') SIZE 102400K
  37. ALTER DATABASE ADD LOGFILE MEMBER '+SUITE8/v8/onlinelog/group_1-2' TO GROUP 1
  38. ALTER DATABASE ADD LOGFILE MEMBER '+SUITE8/v8/onlinelog/group_2-2' TO GROUP 2
  39. ALTER DATABASE ADD LOGFILE MEMBER '+SUITE8/v8/onlinelog/group_3-2' TO GROUP 3;
  40. ALTER DATABASE RENAME FILE '+SUITE8/v8/onlinelog/group_1.257.607532983' TO '+SUITE8/v8/onlinelog/group_1-1'
  41. ALTER DATABASE ADD LOGFILE GROUP 1 ( '+SUITE8/v8/onlinelog/group_1.257.607532983',
  42. '+SUITE8/v8/onlinelog/group_1-2')
  43. SIZE 102400K
  44.  
  45. CREATE SMALLFILE TABLESPACE users
  46. LOGGING
  47. DATAFILE '+SUITE8/v8/users01' SIZE 5M REUSE
  48. AUTOEXTEND ON NEXT 1280K MAXSIZE 32767M
  49. EXTENT MANAGEMENT LOCAL
  50. SEGMENT SPACE MANAGEMENT AUTO
  51.  
  52. ALTER DATABASE DEFAULT TABLESPACE "USERS"
  53.  
  54. CREATE SMALLFILE TABLESPACE v8main
  55. LOGGING
  56. DATAFILE'+SUITE8/v8/v8main01' SIZE 5G REUSE
  57. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  58. '+SUITE8/v8/v8main02' SIZE 5G REUSE
  59. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  60. '+SUITE8/v8/v8main03' SIZE 5G REUSE
  61. AUTOEXTEND ON NEXT 1G MAXSIZE 10G
  62. EXTENT MANAGEMENT LOCAL
  63. SEGMENT SPACE MANAGEMENT AUTO;
  64.  
  65.  
  66. CREATE SMALLFILE TABLESPACE v8large
  67. LOGGING
  68. DATAFILE'+SUITE8/v8/v8large01' SIZE 5G REUSE
  69. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  70. '+SUITE8/v8/v8large02' SIZE 5G REUSE
  71. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  72. '+SUITE8/v8/v8large03' SIZE 5G REUSE
  73. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  74. '+SUITE8/v8/v8large04' SIZE 5G REUSE
  75. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  76. '+SUITE8/v8/v8large05' SIZE 5G REUSE
  77. AUTOEXTEND ON NEXT 1G MAXSIZE 10G
  78. EXTENT MANAGEMENT LOCAL
  79. SEGMENT SPACE MANAGEMENT AUTO;
  80.  
  81. CREATE SMALLFILE TABLESPACE v8index
  82. LOGGING
  83. DATAFILE'+SUITE8/v8/v8index01' SIZE 5G REUSE
  84. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  85. '+SUITE8/v8/v8index02' SIZE 5G REUSE
  86. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  87. '+SUITE8/v8/v8index03' SIZE 5G REUSE
  88. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  89. '+SUITE8/v8/v8index04' SIZE 5G REUSE
  90. AUTOEXTEND ON NEXT 1G MAXSIZE 10G
  91. EXTENT MANAGEMENT LOCAL
  92. SEGMENT SPACE MANAGEMENT AUTO;
  93.  
  94. CREATE SMALLFILE TABLESPACE v8conf
  95. LOGGING
  96. DATAFILE'+SUITE8/v8/v8conf01' SIZE 5G REUSE
  97. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  98. '+SUITE8/v8/v8conf02' SIZE 5G REUSE
  99. AUTOEXTEND ON NEXT 1G MAXSIZE 10G
  100. EXTENT MANAGEMENT LOCAL
  101. SEGMENT SPACE MANAGEMENT AUTO;
  102.  
  103. CREATE SMALLFILE TABLESPACE v8archive
  104. LOGGING
  105. DATAFILE'+SUITE8/v8/v8archive01' SIZE 5G REUSE
  106. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  107. '+SUITE8/v8/v8archive02' SIZE 5G REUSE
  108. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  109. '+SUITE8/v8/v8archive03' SIZE 5G REUSE
  110. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  111. '+SUITE8/v8/v8archive04' SIZE 5G REUSE
  112. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  113. '+SUITE8/v8/v8archive05' SIZE 5G REUSE
  114. AUTOEXTEND ON NEXT 1G MAXSIZE 10G
  115. EXTENT MANAGEMENT LOCAL
  116. SEGMENT SPACE MANAGEMENT AUTO;
  117.  
  118. CREATE SMALLFILE TEMPORARY TABLESPACE v8temp
  119. TEMPFILE '+SUITE8/v8/tempfile/v8temp01' SIZE 1G REUSE
  120. AUTOEXTEND ON NEXT 1G MAXSIZE 5G
  121. EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K;
  122.  
  123. -- ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP"
  124. */
  125.  
  126. CREATE SMALLFILE TABLESPACE v8main
  127. LOGGING
  128. DATAFILE'e:\oracle\oradata\v8\v8main.ora' SIZE 2G REUSE
  129. AUTOEXTEND ON NEXT 1G MAXSIZE 10G
  130. EXTENT MANAGEMENT LOCAL
  131. SEGMENT SPACE MANAGEMENT AUTO;
  132.  
  133.  
  134. CREATE SMALLFILE TABLESPACE v8large
  135. LOGGING
  136. DATAFILE'e:\oracle\oradata\v8\v8large.ora' SIZE 2G REUSE
  137. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  138. 'e:\oracle\oradata\v8\v8large02.ora' SIZE 2G REUSE
  139. AUTOEXTEND ON NEXT 1G MAXSIZE 10G
  140. EXTENT MANAGEMENT LOCAL
  141. SEGMENT SPACE MANAGEMENT AUTO;
  142.  
  143. CREATE SMALLFILE TABLESPACE v8index
  144. LOGGING
  145. DATAFILE'e:\oracle\oradata\v8\v8index.ora' SIZE 2G REUSE
  146. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  147. 'e:\oracle\oradata\v8\v8index02.ora' SIZE 2G REUSE
  148. AUTOEXTEND ON NEXT 1G MAXSIZE 10G
  149. EXTENT MANAGEMENT LOCAL
  150. SEGMENT SPACE MANAGEMENT AUTO;
  151.  
  152. CREATE SMALLFILE TABLESPACE v8conf
  153. LOGGING
  154. DATAFILE'e:\oracle\oradata\v8\v8conf.ora' SIZE 2G REUSE
  155. AUTOEXTEND ON NEXT 1G MAXSIZE 10G
  156. EXTENT MANAGEMENT LOCAL
  157. SEGMENT SPACE MANAGEMENT AUTO;
  158.  
  159. CREATE SMALLFILE TABLESPACE v8archive
  160. LOGGING
  161. DATAFILE'e:\oracle\oradata\v8\v8archive.ora' SIZE 2G REUSE
  162. AUTOEXTEND ON NEXT 1G MAXSIZE 10G ,
  163. 'e:\oracle\oradata\v8\v8archive02.ora' SIZE 2G REUSE
  164. AUTOEXTEND ON NEXT 1G MAXSIZE 10G
  165. EXTENT MANAGEMENT LOCAL
  166. SEGMENT SPACE MANAGEMENT AUTO;
  167.  
  168. CREATE SMALLFILE TEMPORARY TABLESPACE v8temp
  169. TEMPFILE 'e:\oracle\oradata\v8\v8temp.ora' SIZE 1G REUSE
  170. AUTOEXTEND ON NEXT 1G MAXSIZE 5G
  171. EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K;
  172.  
  173.  
  174.  
  175. ==============================================================================
  176.  
  177.  
  178. CREATE USER v8analyze PROFILE default
  179. IDENTIFIED BY v8analyze
  180. DEFAULT TABLESPACE v8main
  181. TEMPORARY TABLESPACE v8temp
  182. ACCOUNT UNLOCK;
  183.  
  184. ALTER USER v8analyze
  185. QUOTA UNLIMITED ON v8conf
  186. QUOTA UNLIMITED ON v8index
  187. QUOTA UNLIMITED ON v8large
  188. QUOTA UNLIMITED ON v8main;
  189.  
  190. GRANT ANALYZE ANY TO v8analyze;
  191. GRANT CREATE ANY INDEX TO v8analyze;
  192. GRANT SELECT ANY DICTIONARY TO v8analyze;
  193. GRANT SELECT ANY TABLE TO v8analyze;
  194. GRANT ALTER ANY TABLE TO v8analyze;
  195. GRANT CONNECT TO v8analyze;
  196.  
  197. ---
  198.  
  199. CREATE USER v8live PROFILE default
  200. IDENTIFIED BY live
  201. DEFAULT TABLESPACE v8main
  202. TEMPORARY TABLESPACE v8temp
  203. ACCOUNT UNLOCK;
  204.  
  205. GRANT connect TO v8live;
  206. GRANT RESOURCE TO v8live;
  207. GRANT create table, create type, create procedure, create view, create trigger TO v8live;
  208. GRANT select on v_$session TO v8live;
  209. GRANT select on v_$database TO v8live;
  210. GRANT select on dba_indexes TO v8live;
  211. GRANT select on dba_tables TO v8live;
  212. GRANT select on v_$sess_io TO v8live;
  213. GRANT select on v_$statname TO v8live;
  214. GRANT select on v_$sql TO v8live;
  215. GRANT select on v_$sysstat TO v8live;
  216.  
  217. ALTER USER v8live
  218. QUOTA UNLIMITED ON v8conf
  219. QUOTA UNLIMITED ON v8index
  220. QUOTA UNLIMITED ON v8large
  221. QUOTA UNLIMITED ON v8main;
  222.  
  223. CREATE USER v8livearc PROFILE default
  224. IDENTIFIED BY v8livearc DEFAULT TABLESPACE v8archive
  225. TEMPORARY TABLESPACE v8temp
  226. ACCOUNT UNLOCK;
  227.  
  228. ALTER USER v8livearc
  229. QUOTA UNLIMITED ON system
  230. QUOTA UNLIMITED ON v8conf
  231. QUOTA UNLIMITED ON v8index
  232. QUOTA UNLIMITED ON v8large
  233. QUOTA UNLIMITED ON v8main
  234. QUOTA UNLIMITED ON v8archive;
  235.  
  236. GRANT SELECT ANY TABLE TO v8livearc;
  237. GRANT UNLIMITED TABLESPACE TO v8livearc;
  238. GRANT CONNECT TO v8livearc;
  239.  
  240. ---
  241.  
  242. CREATE USER v8train PROFILE default
  243. IDENTIFIED BY train
  244. DEFAULT TABLESPACE v8main
  245. TEMPORARY TABLESPACE v8temp
  246. ACCOUNT UNLOCK;
  247.  
  248. GRANT connect TO v8train;
  249. GRANT RESOURCE TO v8train;
  250. GRANT create table, create type, create procedure, create view, create trigger TO v8train;
  251. GRANT select on v_$session TO v8train;
  252. GRANT select on v_$database TO v8train;
  253. GRANT select on dba_indexes TO v8train;
  254. GRANT select on dba_tables TO v8train;
  255. GRANT select on v_$sess_io TO v8train;
  256. GRANT select on v_$statname TO v8train;
  257. GRANT select on v_$sql TO v8train;
  258. GRANT select on v_$sysstat TO v8train;
  259.  
  260. ALTER USER v8train
  261. QUOTA UNLIMITED ON v8conf
  262. QUOTA UNLIMITED ON v8index
  263. QUOTA UNLIMITED ON v8large
  264. QUOTA UNLIMITED ON v8main;
  265.  
  266. CREATE USER v8trainarc PROFILE default
  267. IDENTIFIED BY v8trainarc
  268. DEFAULT TABLESPACE v8archive
  269. TEMPORARY TABLESPACE v8temp
  270. ACCOUNT UNLOCK;
  271.  
  272. ALTER USER v8trainarc
  273. QUOTA UNLIMITED ON system
  274. QUOTA UNLIMITED ON v8conf
  275. QUOTA UNLIMITED ON v8index
  276. QUOTA UNLIMITED ON v8large
  277. QUOTA UNLIMITED ON v8main
  278. QUOTA UNLIMITED ON v8archive;
  279.  
  280. GRANT SELECT ANY TABLE TO v8trainarc;
  281. GRANT UNLIMITED TABLESPACE TO v8trainarc;
  282. GRANT CONNECT TO v8trainarc;
  283.  
  284. -- ===========================================================================
  285.  
  286. BEGIN
  287. dbms_resource_manager.clear_pending_area();
  288. dbms_resource_manager.create_pending_area();
  289. dbms_resource_manager.update_plan_directive(
  290. plan => 'SYSTEM_PLAN',
  291. group_or_subplan => 'LOW_GROUP',
  292. new_comment => ' ',
  293. new_cpu_p1 => 20, new_cpu_p2 => 20, new_cpu_p3 => 20, new_cpu_p4 => 0,
  294. new_cpu_p5 => 0, new_cpu_p6 => 0, new_cpu_p7 => 0, new_cpu_p8 => 0,
  295. new_parallel_degree_limit_p1 => -1,
  296. new_active_sess_pool_p1 => -1,
  297. new_queueing_p1 => -1,
  298. new_switch_group => '',
  299. new_switch_time => -1,
  300. new_switch_estimate => false,
  301. new_max_est_exec_time => -1,
  302. new_undo_pool => -1
  303. );
  304. dbms_resource_manager.update_plan_directive(
  305. plan => 'SYSTEM_PLAN',
  306. group_or_subplan => 'OTHER_GROUPS',
  307. new_comment => ' ',
  308. new_cpu_p1 => 40, new_cpu_p2 => 40, new_cpu_p3 => 40, new_cpu_p4 => 0,
  309. new_cpu_p5 => 0, new_cpu_p6 => 0, new_cpu_p7 => 0, new_cpu_p8 => 0,
  310. new_parallel_degree_limit_p1 => -1,
  311. new_active_sess_pool_p1 => -1,
  312. new_queueing_p1 => -1,
  313. new_switch_group => '',
  314. new_switch_time => -1,
  315. new_switch_estimate => false,
  316. new_max_est_exec_time => -1,
  317. new_undo_pool => -1
  318. );
  319. dbms_resource_manager.update_plan_directive(
  320. plan => 'SYSTEM_PLAN',
  321. group_or_subplan => 'SYS_GROUP',
  322. new_comment => ' ',
  323. new_cpu_p1 => 40, new_cpu_p2 => 40, new_cpu_p3 => 40, new_cpu_p4 => 0,
  324. new_cpu_p5 => 0, new_cpu_p6 => 0, new_cpu_p7 => 0, new_cpu_p8 => 0,
  325. new_parallel_degree_limit_p1 => -1,
  326. new_active_sess_pool_p1 => -1,
  327. new_queueing_p1 => -1,
  328. new_switch_group => '',
  329. new_switch_time => -1,
  330. new_switch_estimate => false,
  331. new_max_est_exec_time => -1,
  332. new_undo_pool => -1
  333. );
  334. dbms_resource_manager.submit_pending_area();
  335. END;
  336. /
  337.  
  338. BEGIN
  339. dbms_resource_manager_privs.grant_switch_consumer_group(grantee_name => 'V8LIVE',
  340. consumer_group => 'DEFAULT_CONSUMER_GROUP',
  341. grant_option => FALSE);
  342. END;
  343. /
  344.  
  345. BEGIN
  346. dbms_resource_manager_privs.grant_switch_consumer_group(grantee_name => 'V8LIVEARC',
  347. consumer_group => 'DEFAULT_CONSUMER_GROUP',
  348. grant_option => FALSE);
  349. END;
  350. /
  351.  
  352.  
  353. BEGIN
  354. dbms_resource_manager_privs.grant_switch_consumer_group(grantee_name => 'V8TRAIN',
  355. consumer_group => 'LOW_GROUP',
  356. grant_option => FALSE);
  357. END;
  358. /
  359.  
  360. BEGIN
  361. dbms_resource_manager_privs.grant_switch_consumer_group(grantee_name => 'V8TRAINARC',
  362. consumer_group => 'LOW_GROUP',
  363. grant_option => FALSE);
  364. END;
  365. /
  366.  
  367.  
  368. BEGIN
  369. dbms_resource_manager_privs.grant_switch_consumer_group(grantee_name => 'V8ANALYZE',
  370. consumer_group => 'LOW_GROUP',
  371. grant_option => FALSE);
  372. END;
  373. /
  374.  
  375. BEGIN
  376. dbms_resource_manager.set_initial_consumer_group(user => 'V8TRAIN',
  377. consumer_group => 'LOW_GROUP');
  378. END;
  379. /
  380.  
  381. BEGIN
  382. dbms_resource_manager.set_initial_consumer_group(user => 'V8TRAINARC',
  383. consumer_group => 'LOW_GROUP');
  384. END;
  385. /
  386.  
  387. BEGIN
  388. dbms_resource_manager.set_initial_consumer_group(user => 'V8ANALYZE',
  389. consumer_group => 'LOW_GROUP');
  390. END;
  391. /
  392.  
  393. ALTER SYSTEM SET resource_manager_plan = 'SYSTEM_PLAN' SCOPE=both SID='*';
  394.  
  395. -- ===========================================================================
  396.  
  397. CREATE TABLE v8livearc.wlog (WLOG_ID NUMBER(30,0) NOT NULL ENABLE,
  398. WLOG_XCED_ID NUMBER(30,0) NOT NULL ENABLE,
  399. WLOG_WPCA_ID NUMBER(30,0) NOT NULL ENABLE,
  400. WLOG_TIME DATE NOT NULL ENABLE,
  401. WLOG_TYPE NUMBER(3,0) NOT NULL ENABLE,
  402. WLOG_TABLE_ID NUMBER(30,0) NOT NULL ENABLE,
  403. WLOG_TEXT VARCHAR2(200 BYTE) NOT NULL ENABLE,
  404. WLOG_SYSDAT DATE NOT NULL ENABLE,
  405. WLOG_TABLENAME CHAR(4 BYTE) NOT NULL ENABLE,
  406. CONSTRAINT WLOG_PK PRIMARY KEY (WLOG_ID) ENABLE);
  407.  
  408. CREATE TABLE v8livearc.WTXT (WTXT_ID NUMBER(30,0) NOT NULL ENABLE,
  409. WTXT_DATA LONG RAW,
  410. WTXT_DOCFORMAT NUMBER(1,0),
  411. CONSTRAINT WTXT_PK PRIMARY KEY (WTXT_ID) ENABLE);
  412.  
  413. CREATE TABLE v8livearc.ZCHE (ZCHE_ID NUMBER(30,0) NOT NULL ENABLE,
  414. ZCHE_GUESTCHECK LONG NOT NULL ENABLE,
  415. ZCHE_CHECKDATE DATE NOT NULL ENABLE,
  416. ZCHE_CHECKNUM VARCHAR2(20 BYTE) NOT NULL ENABLE,
  417. CONSTRAINT ZCHE_PK PRIMARY KEY (ZCHE_ID) ENABLE);
  418.  
  419. CREATE TABLE v8livearc.ZDAT (ZDAT_ID NUMBER(30,0) NOT NULL ENABLE,
  420. ZDAT_DATA LONG RAW NOT NULL ENABLE,
  421. ZDAT_PAGENUM NUMBER(10,0),
  422. ZDAT_RESOURCE_NAME VARCHAR2(60 BYTE),
  423. ZDAT_RESOURCE_TIMESTAMP DATE,
  424. ZDAT_TYPE NUMBER(2,0),
  425. ZDAT_LINKTABLE_NAME VARCHAR2(4 BYTE),
  426. ZDAT_LINKTABLE_ID NUMBER(30,0),
  427. CONSTRAINT ZDAT_PK PRIMARY KEY (ZDAT_ID) ENABLE);
  428.  
  429. CREATE INDEX v8livearc.ZDAT_RESOURCE_NAME ON v8livearc.ZDAT (ZDAT_RESOURCE_NAME);
  430. CREATE INDEX v8livearc.ZDAT_PAGENUM ON v8livearc.ZDAT (ZDAT_PAGENUM);
  431. CREATE INDEX v8livearc.ZDAT_TYPE ON v8livearc.ZDAT (ZDAT_TYPE);
  432. CREATE INDEX v8livearc.ZDAT_LINKTABLE_NAME ON v8livearc.ZDAT (ZDAT_LINKTABLE_NAME);
  433. CREATE INDEX v8livearc.ZDAT_LINKTABLE_ID ON v8livearc.ZDAT (ZDAT_LINKTABLE_ID);
  434.  
  435. CREATE TABLE v8livearc.ZINB (ZINB_ID NUMBER(30,0) NOT NULL ENABLE,
  436. ZINB_EDITOR_XCMS_ID NUMBER(30,0),
  437. ZINB_DATA LONG RAW,
  438. ZINB_TYPE NUMBER(2,0),
  439. ZINB_PARENT_ZINB_ID NUMBER(30,0),
  440. ZINB_EDITOR_DATETIME DATE,
  441. ZINB_REVISION_NUMBER NUMBER(30,0),
  442. ZINB_NOTE VARCHAR2(200 BYTE),
  443. ZINB_COMPRESSED NUMBER(1,0),
  444. CONSTRAINT ZINB_PK PRIMARY KEY (ZINB_ID) ENABLE);
  445.  
  446. CREATE INDEX v8livearc.ZINB_REVISION_NUMBER ON v8livearc.ZINB (ZINB_REVISION_NUMBER);
  447. CREATE INDEX v8livearc.ZINB_TYPE ON v8livearc.ZINB (ZINB_TYPE);
  448. CREATE INDEX v8livearc.ZINB_COMPRESSED ON v8livearc.ZINB (ZINB_COMPRESSED);
  449. CREATE INDEX v8livearc.ZINB_EDITOR_XCMS_ID ON v8livearc.ZINB (ZINB_EDITOR_XCMS_ID);
  450. CREATE INDEX v8livearc.ZINB_PARENT_ZINB_ID ON v8livearc.ZINB (ZINB_PARENT_ZINB_ID);
  451.  
  452. CREATE TABLE v8livearc.ZTXT (ZTXT_ID NUMBER(30,0) NOT NULL ENABLE,
  453. ZTXT_USER_XCMS_ID NUMBER(30,0),
  454. ZTXT_WRPT_ID NUMBER(30,0),
  455. ZTXT_DATA LONG RAW,
  456. ZTXT_TYPE NUMBER(2,0),
  457. ZTXT_TIME DATE,
  458. ZTXT_COPIES NUMBER(2,0),
  459. ZTXT_TABLELINKEDTO CHAR(4 BYTE),
  460. ZTXT_TABLE_ID NUMBER(30,0),
  461. ZTXT_EXPORTTYPE NUMBER(1,0),
  462. ZTXT_DATE DATE,
  463. CONSTRAINT ZTXT_PK PRIMARY KEY (ZTXT_ID) ENABLE);
  464.  
  465. GRANT DELETE ON v8livearc.wlog TO v8live;
  466. GRANT INSERT ON v8livearc.wlog TO v8live;
  467. GRANT SELECT ON v8livearc.wlog TO v8live;
  468. GRANT UPDATE ON v8livearc.wlog TO v8live;
  469. GRANT DELETE ON v8livearc.wtxt TO v8live;
  470. GRANT INSERT ON v8livearc.wtxt TO v8live;
  471. GRANT SELECT ON v8livearc.wtxt TO v8live;
  472. GRANT UPDATE ON v8livearc.wtxt TO v8live;
  473. GRANT DELETE ON v8livearc.zche TO v8live;
  474. GRANT INSERT ON v8livearc.zche TO v8live;
  475. GRANT SELECT ON v8livearc.zche TO v8live;
  476. GRANT UPDATE ON v8livearc.zche TO v8live;
  477. GRANT DELETE ON v8livearc.zdat TO v8live;
  478. GRANT INSERT ON v8livearc.zdat TO v8live;
  479. GRANT SELECT ON v8livearc.zdat TO v8live;
  480. GRANT UPDATE ON v8livearc.zdat TO v8live;
  481. GRANT DELETE ON v8livearc.zinb TO v8live;
  482. GRANT INSERT ON v8livearc.zinb TO v8live;
  483. GRANT SELECT ON v8livearc.zinb TO v8live;
  484. GRANT UPDATE ON v8livearc.zinb TO v8live;
  485. GRANT DELETE ON v8livearc.ztxt TO v8live;
  486. GRANT INSERT ON v8livearc.ztxt TO v8live;
  487. GRANT SELECT ON v8livearc.ztxt TO v8live;
  488. GRANT UPDATE ON v8livearc.ztxt TO v8live;
  489.  
  490. -- v8trainarc tables
  491.  
  492. CREATE TABLE v8trainarc.wlog (WLOG_ID NUMBER(30,0) NOT NULL ENABLE,
  493. WLOG_XCED_ID NUMBER(30,0) NOT NULL ENABLE,
  494. WLOG_WPCA_ID NUMBER(30,0) NOT NULL ENABLE,
  495. WLOG_TIME DATE NOT NULL ENABLE,
  496. WLOG_TYPE NUMBER(3,0) NOT NULL ENABLE,
  497. WLOG_TABLE_ID NUMBER(30,0) NOT NULL ENABLE,
  498. WLOG_TEXT VARCHAR2(200 BYTE) NOT NULL ENABLE,
  499. WLOG_SYSDAT DATE NOT NULL ENABLE,
  500. WLOG_TABLENAME CHAR(4 BYTE) NOT NULL ENABLE,
  501. CONSTRAINT WLOG_PK PRIMARY KEY (WLOG_ID) ENABLE);
  502.  
  503. CREATE TABLE v8trainarc.WTXT (WTXT_ID NUMBER(30,0) NOT NULL ENABLE,
  504. WTXT_DATA LONG RAW,
  505. WTXT_DOCFORMAT NUMBER(1,0),
  506. CONSTRAINT WTXT_PK PRIMARY KEY (WTXT_ID) ENABLE);
  507.  
  508. CREATE TABLE v8trainarc.ZCHE (ZCHE_ID NUMBER(30,0) NOT NULL ENABLE,
  509. ZCHE_GUESTCHECK LONG NOT NULL ENABLE,
  510. ZCHE_CHECKDATE DATE NOT NULL ENABLE,
  511. ZCHE_CHECKNUM VARCHAR2(20 BYTE) NOT NULL ENABLE,
  512. CONSTRAINT ZCHE_PK PRIMARY KEY (ZCHE_ID) ENABLE);
  513.  
  514. CREATE TABLE v8trainarc.ZDAT (ZDAT_ID NUMBER(30,0) NOT NULL ENABLE,
  515. ZDAT_DATA LONG RAW NOT NULL ENABLE,
  516. ZDAT_PAGENUM NUMBER(10,0),
  517. ZDAT_RESOURCE_NAME VARCHAR2(60 BYTE),
  518. ZDAT_RESOURCE_TIMESTAMP DATE,
  519. ZDAT_TYPE NUMBER(2,0),
  520. ZDAT_LINKTABLE_NAME VARCHAR2(4 BYTE),
  521. ZDAT_LINKTABLE_ID NUMBER(30,0),
  522. CONSTRAINT ZDAT_PK PRIMARY KEY (ZDAT_ID) ENABLE);
  523.  
  524. CREATE INDEX v8trainarc.ZDAT_RESOURCE_NAME ON v8trainarc.ZDAT (ZDAT_RESOURCE_NAME);
  525. CREATE INDEX v8trainarc.ZDAT_PAGENUM ON v8trainarc.ZDAT (ZDAT_PAGENUM);
  526. CREATE INDEX v8trainarc.ZDAT_TYPE ON v8trainarc.ZDAT (ZDAT_TYPE);
  527. CREATE INDEX v8trainarc.ZDAT_LINKTABLE_NAME ON v8trainarc.ZDAT (ZDAT_LINKTABLE_NAME);
  528. CREATE INDEX v8trainarc.ZDAT_LINKTABLE_ID ON v8trainarc.ZDAT (ZDAT_LINKTABLE_ID);
  529.  
  530. CREATE TABLE v8trainarc.ZINB (ZINB_ID NUMBER(30,0) NOT NULL ENABLE,
  531. ZINB_EDITOR_XCMS_ID NUMBER(30,0),
  532. ZINB_DATA LONG RAW,
  533. ZINB_TYPE NUMBER(2,0),
  534. ZINB_PARENT_ZINB_ID NUMBER(30,0),
  535. ZINB_EDITOR_DATETIME DATE,
  536. ZINB_REVISION_NUMBER NUMBER(30,0),
  537. ZINB_NOTE VARCHAR2(200 BYTE),
  538. ZINB_COMPRESSED NUMBER(1,0),
  539. CONSTRAINT ZINB_PK PRIMARY KEY (ZINB_ID) ENABLE);
  540.  
  541. CREATE INDEX v8trainarc.ZINB_REVISION_NUMBER ON v8trainarc.ZINB (ZINB_REVISION_NUMBER);
  542. CREATE INDEX v8trainarc.ZINB_TYPE ON v8trainarc.ZINB (ZINB_TYPE);
  543. CREATE INDEX v8trainarc.ZINB_COMPRESSED ON v8trainarc.ZINB (ZINB_COMPRESSED);
  544. CREATE INDEX v8trainarc.ZINB_EDITOR_XCMS_ID ON v8trainarc.ZINB (ZINB_EDITOR_XCMS_ID);
  545. CREATE INDEX v8trainarc.ZINB_PARENT_ZINB_ID ON v8trainarc.ZINB (ZINB_PARENT_ZINB_ID);
  546.  
  547. CREATE TABLE v8trainarc.ZTXT (ZTXT_ID NUMBER(30,0) NOT NULL ENABLE,
  548. ZTXT_USER_XCMS_ID NUMBER(30,0),
  549. ZTXT_WRPT_ID NUMBER(30,0),
  550. ZTXT_DATA LONG RAW,
  551. ZTXT_TYPE NUMBER(2,0),
  552. ZTXT_TIME DATE,
  553. ZTXT_COPIES NUMBER(2,0),
  554. ZTXT_TABLELINKEDTO CHAR(4 BYTE),
  555. ZTXT_TABLE_ID NUMBER(30,0),
  556. ZTXT_EXPORTTYPE NUMBER(1,0),
  557. ZTXT_DATE DATE,
  558. CONSTRAINT ZTXT_PK PRIMARY KEY (ZTXT_ID) ENABLE);
  559.  
  560. GRANT DELETE ON v8trainarc.wlog TO v8train;
  561. GRANT INSERT ON v8trainarc.wlog TO v8train;
  562. GRANT SELECT ON v8trainarc.wlog TO v8train;
  563. GRANT UPDATE ON v8trainarc.wlog TO v8train;
  564. GRANT DELETE ON v8trainarc.wtxt TO v8train;
  565. GRANT INSERT ON v8trainarc.wtxt TO v8train;
  566. GRANT SELECT ON v8trainarc.wtxt TO v8train;
  567. GRANT UPDATE ON v8trainarc.wtxt TO v8train;
  568. GRANT DELETE ON v8trainarc.zche TO v8train;
  569. GRANT INSERT ON v8trainarc.zche TO v8train;
  570. GRANT SELECT ON v8trainarc.zche TO v8train;
  571. GRANT UPDATE ON v8trainarc.zche TO v8train;
  572. GRANT DELETE ON v8trainarc.zdat TO v8train;
  573. GRANT INSERT ON v8trainarc.zdat TO v8train;
  574. GRANT SELECT ON v8trainarc.zdat TO v8train;
  575. GRANT UPDATE ON v8trainarc.zdat TO v8train;
  576. GRANT DELETE ON v8trainarc.zinb TO v8train;
  577. GRANT INSERT ON v8trainarc.zinb TO v8train;
  578. GRANT SELECT ON v8trainarc.zinb TO v8train;
  579. GRANT UPDATE ON v8trainarc.zinb TO v8train;
  580. GRANT DELETE ON v8trainarc.ztxt TO v8train;
  581. GRANT INSERT ON v8trainarc.ztxt TO v8train;
  582. GRANT SELECT ON v8trainarc.ztxt TO v8train;
  583. GRANT UPDATE ON v8trainarc.ztxt TO v8train;
  584.  
  585. -- SYSDUAL
  586.  
  587. DECLARE
  588. file_location VARCHAR2(50);
  589. drive_letter_loc NUMBER;
  590. create_tblspace VARCHAR2(200);
  591. myexit EXCEPTION;
  592.  
  593. CURSOR get_system_data IS
  594. SELECT SUBSTR(file_name, 0, (INSTR(file_name, '\', -3, 1))) FROM dba_data_files WHERE tablespace_name = 'SYSTEM';
  595.  
  596. BEGIN
  597. OPEN get_system_data;
  598. FETCH get_system_data INTO file_location;
  599. CLOSE get_system_data;
  600. IF INSTR(file_location,':\')=0 THEN
  601. RAISE myexit;
  602. ELSE
  603. create_tblspace := 'CREATE SMALLFILE TABLESPACE sysdual LOGGING DATAFILE ' ||CHR(39)|| file_location ||'SYSDUAL.ORA'||CHR(39) ||' SIZE 25M REUSE AUTOEXTEND ON NEXT 5M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M';
  604. BEGIN
  605. EXECUTE IMMEDIATE create_tblspace;
  606. EXCEPTION WHEN others THEN null;
  607. END;
  608. BEGIN
  609. EXECUTE IMMEDIATE 'ALTER TABLE dual MOVE TABLESPACE sysdual';
  610. EXCEPTION WHEN others THEN null;
  611. END;
  612. BEGIN
  613. EXECUTE IMMEDIATE 'ALTER TABLESPACE sysdual READ ONLY';
  614. EXCEPTION WHEN others THEN null;
  615. END;
  616. BEGIN
  617. EXECUTE IMMEDIATE 'CREATE OR REPLACE PUBLIC SYNONYM dual FOR sys.dual';
  618. EXCEPTION WHEN others THEN null;
  619. END;
  620. END IF;
  621. EXCEPTION WHEN others THEN null;
  622. END;
  623. /
  624.  
  625.  
  626. COL file_name FOR a40
  627. SELECT df.file_name, d.enabled
  628. FROM dba_data_files df, v$datafile d
  629. WHERE df.file_name = d.name
  630. ORDER BY df.tablespace_name;
  631.  
  632. SELECT table_name, tablespace_name FROM dba_tables WHERE table_name = 'DUAL';
  633.  
  634. -- Login Trigger
  635.  
  636. CREATE OR REPLACE TRIGGER system.LoginOnSchemaTrigger
  637. AFTER LOGON ON system.schema
  638. BEGIN
  639. EXECUTE IMMEDIATE
  640. 'ALTER SESSION SET optimizer_mode=ALL_ROWS';
  641. END;
  642. /
  643.  
  644. CREATE OR REPLACE TRIGGER system.LoginOnDBTrigger
  645. AFTER LOGON ON DATABASE
  646. BEGIN
  647. EXECUTE IMMEDIATE
  648. 'ALTER SESSION SET optimizer_mode=ALL_ROWS';
  649. END;
  650. /
  651.  
  652. IMP "system/oracle@v8" fromuser=v8master touser=v8master buffer=2048000 file=v8master.dmp log=v8master-import.log statistics=none
  653.  
  654. IMP "system/oracle@v8" fromuser=v8analyze touser=v8analyze buffer=2048000 file=v8analyze.dmp log=v8analyze-import.log statistics=none
  655.  
  656. IMP "system/oracle@v8" fromuser=v8live touser=v8live buffer=2048000 file=v8live.dmp log=v8live-import.log statistics=none
  657.  
  658. IMP "system/oracle@v8" fromuser=v8livearc touser=v8livearc buffer=2048000 file=v8livearc.dmp log=v8livearc-import.log statistics=none
  659.  
  660. -- MC Tables
  661.  
  662. CREATE SMALLFILE TABLESPACE mcmain
  663. LOGGING
  664. DATAFILE SIZE 512M
  665. AUTOEXTEND ON NEXT 512M
  666. MAXSIZE 5120M
  667. EXTENT MANAGEMENT LOCAL
  668. SEGMENT SPACE MANAGEMENT AUTO;
  669.  
  670. CREATE SMALLFILE TEMPORARY TABLESPACE mctemp
  671. TEMPFILE SIZE 256M
  672. AUTOEXTEND ON NEXT 256M MAXSIZE 1024M
  673. EXTENT MANAGEMENT LOCAL
  674. UNIFORM SIZE 1024K;
  675.  
  676. -- MC User
  677.  
  678. CREATE USER mcdata PROFILE default
  679. IDENTIFIED BY micros
  680. DEFAULT TABLESPACE mcmain
  681. TEMPORARY TABLESPACE mctemp
  682. ACCOUNT UNLOCK;
  683. GRANT CONNECT TO mcdata;
  684. GRANT RESOURCE TO mcdata;
  685. ALTER USER mcdata
  686. QUOTA UNLIMITED ON mcmain;
  687.  
  688. CREATE USER mctrain PROFILE default
  689. IDENTIFIED BY micros
  690. DEFAULT TABLESPACE mcmain
  691. TEMPORARY TABLESPACE mctemp
  692. ACCOUNT UNLOCK;
  693. GRANT CONNECT TO mctrain;
  694. GRANT RESOURCE TO mcdata;
  695. ALTER USER mctrain
  696. QUOTA UNLIMITED ON mcmain;
  697.  
  698.  
  699. BEGIN
  700. dbms_resource_manager_privs.grant_switch_consumer_group(grantee_name => 'MCDATA',
  701. consumer_group => 'DEFAULT_CONSUMER_GROUP',
  702. grant_option => FALSE);
  703. END;
  704. /
  705.  
  706. BEGIN
  707. dbms_resource_manager.set_initial_consumer_group(user => 'MCDATA',
  708. consumer_group => 'DEFAULT_CONSUMER_GROUP');
  709. END;
  710. /
  711.  
  712. BEGIN
  713. dbms_resource_manager_privs.grant_switch_consumer_group(grantee_name => 'MCTRAIN',
  714. consumer_group => 'LOW_GROUP',
  715. grant_option => FALSE);
  716. END;
  717. /
  718.  
  719. BEGIN
  720. dbms_resource_manager.set_initial_consumer_group(user => 'MCTRAIN',
  721. consumer_group => 'LOW_GROUP');
  722. END;
  723. /
  724.  
  725. -- MFPOS V8 Tables
  726.  
  727. CREATE SMALLFILE TABLESPACE mfmain
  728. LOGGING
  729. DATAFILE SIZE 512M
  730. AUTOEXTEND ON NEXT 512M
  731. MAXSIZE 5120M
  732. EXTENT MANAGEMENT LOCAL
  733. SEGMENT SPACE MANAGEMENT AUTO;
  734.  
  735. CREATE SMALLFILE TABLESPACE mfconf
  736. LOGGING
  737. DATAFILE SIZE 256M
  738. AUTOEXTEND ON NEXT 256M
  739. MAXSIZE 2560M
  740. EXTENT MANAGEMENT LOCAL
  741. SEGMENT SPACE MANAGEMENT AUTO;
  742.  
  743. CREATE SMALLFILE TABLESPACE mflarge
  744. LOGGING
  745. DATAFILE SIZE 512M
  746. AUTOEXTEND ON NEXT 512M
  747. MAXSIZE 5120M
  748. EXTENT MANAGEMENT LOCAL
  749. SEGMENT SPACE MANAGEMENT AUTO;
  750.  
  751. CREATE SMALLFILE TABLESPACE mfindex
  752. LOGGING
  753. DATAFILE SIZE 512M
  754. AUTOEXTEND ON NEXT 512M
  755. MAXSIZE 5120M
  756. EXTENT MANAGEMENT LOCAL
  757. SEGMENT SPACE MANAGEMENT AUTO;
  758.  
  759. CREATE SMALLFILE TEMPORARY TABLESPACE mftemp
  760. TEMPFILE SIZE 256M
  761. AUTOEXTEND ON NEXT 256M MAXSIZE 1024M
  762. EXTENT MANAGEMENT LOCAL
  763. UNIFORM SIZE 1024K;
  764.  
  765.  
  766.  
  767. -- MFPOS V8 User
  768.  
  769. CREATE USER mfpos
  770. IDENTIFIED BY lled
  771. DEFAULT TABLESPACE mfmain
  772. TEMPORARY TABLESPACE mftemp;
  773. GRANT CONNECT TO mfpos;
  774. GRANT RESOURCE TO mfpos;
  775. GRANT CREATE ANY SEQUENCE TO mfpos;
  776. GRANT CREATE ANY VIEW TO mfpos;
  777. GRANT CREATE TABLE TO mfpos;
  778. GRANT CREATE PROCEDURE TO mfpos;
  779. GRANT CREATE TYPE TO mfpos;
  780. GRANT CREATE ANY SEQUENCE TO mfpos;
  781. GRANT CREATE TRIGGER TO mfpos;
  782. GRANT SELECT ON SYS.DBA_INDEXES TO mfpos;
  783. GRANT SELECT ON SYS.DBA_TABLES TO mfpos;
  784. GRANT SELECT ON SYS.V_$DATABASE TO mfpos;
  785. GRANT SELECT ON SYS.V_$SESSION TO mfpos;
  786. GRANT SELECT ON SYS.V_$SESS_IO TO mfpos;
  787. GRANT SELECT ON SYS.V_$SQL TO mfpos;
  788. GRANT SELECT ON SYS.V_$STATNAME TO mfpos;
  789. GRANT SELECT ON SYS.V_$SYSSTAT TO mfpos;
  790. GRANT SELECT ON v8live.V8_POS8_PROFILESEARCH to mfpos;
  791. ALTER USER mfpos
  792. QUOTA UNLIMITED ON SYSTEM
  793. QUOTA UNLIMITED ON mfmain
  794. QUOTA UNLIMITED ON mfconf
  795. QUOTA UNLIMITED ON mflarge
  796. QUOTA UNLIMITED ON mfindex;
  797.  
  798. -- Mit MC
  799.  
  800. GRANT SELECT ON mcdata.PRODUKTGRUPPE to mfpos;
  801. GRANT SELECT ON mcdata.SPARTEGR to mfpos;
  802. GRANT SELECT ON mcdata.SPARTE to mfpos;
  803. GRANT SELECT ON mcdata.DEVICE to mfpos;
  804. GRANT SELECT ON mcdata.PRODUKT to mfpos;
  805. GRANT SELECT ON mcdata.REZEPTUR to mfpos;
  806. GRANT SELECT ON mcdata.REZGRUPPE to mfpos;
  807. GRANT SELECT ON mcdata.KOSTST to mfpos;
  808. GRANT SELECT ON mcdata.POSIFC to mfpos;
  809. GRANT SELECT ON mcdata.STEUERN to mfpos;
  810. GRANT SELECT ON mcdata.STEUERTB to mfpos;
  811. GRANT SELECT ON mcdata.PROFILE to mfpos;
  812.  
  813. GRANT UPDATE ON mcdata.PRODUKTGRUPPE to mfpos;
  814. GRANT UPDATE ON mcdata.SPARTEGR to mfpos;
  815. GRANT UPDATE ON mcdata.SPARTE to mfpos;
  816. GRANT UPDATE ON mcdata.DEVICE to mfpos;
  817. GRANT UPDATE ON mcdata.PRODUKT to mfpos;
  818. GRANT UPDATE ON mcdata.REZEPTUR to mfpos;
  819. GRANT UPDATE ON mcdata.REZGRUPPE to mfpos;
  820. GRANT UPDATE ON mcdata.KOSTST to mfpos;
  821. GRANT UPDATE ON mcdata.POSIFC to mfpos;
  822. GRANT UPDATE ON mcdata.STEUERN to mfpos;
  823. GRANT UPDATE ON mcdata.STEUERTB to mfpos;
  824. GRANT UPDATE ON mcdata.PROFILE to mfpos;
  825.  
  826. GRANT INSERT ON mcdata.PRODUKTGRUPPE to mfpos;
  827. GRANT INSERT ON mcdata.SPARTEGR to mfpos;
  828. GRANT INSERT ON mcdata.SPARTE to mfpos;
  829. GRANT INSERT ON mcdata.DEVICE to mfpos;
  830. GRANT INSERT ON mcdata.PRODUKT to mfpos;
  831. GRANT INSERT ON mcdata.REZEPTUR to mfpos;
  832. GRANT INSERT ON mcdata.REZGRUPPE to mfpos;
  833. GRANT INSERT ON mcdata.KOSTST to mfpos;
  834. GRANT INSERT ON mcdata.POSIFC to mfpos;
  835. GRANT INSERT ON mcdata.STEUERN to mfpos;
  836. GRANT INSERT ON mcdata.STEUERTB to mfpos;
  837. GRANT INSERT ON mcdata.PROFILE to mfpos;
  838.  
  839.  
  840.  
  841. CREATE USER mftrain
  842. IDENTIFIED BY lled
  843. DEFAULT TABLESPACE mfmain
  844. TEMPORARY TABLESPACE mftemp;
  845. GRANT CONNECT TO mftrain;
  846. GRANT RESOURCE TO mftrain;
  847. GRANT CREATE ANY SEQUENCE TO mftrain;
  848. GRANT CREATE ANY VIEW TO mftrain;
  849. GRANT CREATE TABLE TO mftrain;
  850. GRANT CREATE PROCEDURE TO mftrain;
  851. GRANT CREATE TYPE TO mftrain;
  852. GRANT CREATE ANY SEQUENCE TO mftrain;
  853. GRANT CREATE TRIGGER TO mftrain;
  854. GRANT SELECT ON SYS.DBA_INDEXES TO mftrain;
  855. GRANT SELECT ON SYS.DBA_TABLES TO mftrain;
  856. GRANT SELECT ON SYS.V_$DATABASE TO mftrain;
  857. GRANT SELECT ON SYS.V_$SESSION TO mftrain;
  858. GRANT SELECT ON SYS.V_$SESS_IO TO mftrain;
  859. GRANT SELECT ON SYS.V_$SQL TO mftrain;
  860. GRANT SELECT ON SYS.V_$STATNAME TO mftrain;
  861. GRANT SELECT ON SYS.V_$SYSSTAT TO mftrain;
  862. GRANT SELECT ON v8live.V8_POS8_PROFILESEARCH to mftrain;
  863. ALTER USER mftrain
  864. QUOTA UNLIMITED ON SYSTEM
  865. QUOTA UNLIMITED ON mfmain
  866. QUOTA UNLIMITED ON mfconf
  867. QUOTA UNLIMITED ON mflarge
  868. QUOTA UNLIMITED ON mfindex;
  869.  
  870.  
  871. BEGIN
  872. dbms_resource_manager_privs.grant_switch_consumer_group(grantee_name => 'MFPOS',
  873. consumer_group => 'LOW_GROUP',
  874. grant_option => FALSE);
  875. END;
  876. /
  877.  
  878. BEGIN
  879. dbms_resource_manager.set_initial_consumer_group(user => 'MFPOS',
  880. consumer_group => 'LOW_GROUP');
  881. END;
  882. /
  883. BEGIN
  884. dbms_resource_manager_privs.grant_switch_consumer_group(grantee_name => 'MFTRAIN',
  885. consumer_group => 'LOW_GROUP',
  886. grant_option => FALSE);
  887. END;
  888. /
  889.  
  890. BEGIN
  891. dbms_resource_manager.set_initial_consumer_group(user => 'MFTRAIN',
  892. consumer_group => 'LOW_GROUP');
  893. END;
  894. /
  895.  
  896.  
  897.  
  898.  
  899. --- Konvertierungs User V8
  900.  
  901. CREATE USER FOCONV PROFILE default
  902. IDENTIFIED BY live
  903. DEFAULT TABLESPACE v8main
  904. TEMPORARY TABLESPACE v8temp
  905. ACCOUNT UNLOCK;
  906.  
  907. GRANT connect TO FOCONV;
  908. GRANT create table, create type, create procedure, create view, create trigger TO FOCONV;
  909. GRANT select on v_$session TO FOCONV;
  910. GRANT select on v_$database TO FOCONV;
  911. GRANT select on dba_indexes TO FOCONV;
  912. GRANT select on dba_tables TO FOCONV;
  913. GRANT select on v_$sess_io TO FOCONV;
  914. GRANT select on v_$statname TO FOCONV;
  915. GRANT select on v_$sql TO FOCONV;
  916. GRANT select on v_$sysstat TO FOCONV;
  917.  
  918. ALTER USER FOCONV
  919. QUOTA UNLIMITED ON v8conf
  920. QUOTA UNLIMITED ON v8index
  921. QUOTA UNLIMITED ON v8large
  922. QUOTA UNLIMITED ON v8main;
  923.  
  924. grant dba to FOCONV;
  925.  
  926.  
  927. CREATE USER FODATA PROFILE default
  928. IDENTIFIED BY live
  929. DEFAULT TABLESPACE v8main
  930. TEMPORARY TABLESPACE v8temp
  931. ACCOUNT UNLOCK;
  932.  
  933. GRANT connect TO FODATA;
  934. GRANT create table, create type, create procedure, create view, create trigger TO FODATA;
  935. GRANT select on v_$session TO FODATA;
  936. GRANT select on v_$database TO FODATA;
  937. GRANT select on dba_indexes TO FODATA;
  938. GRANT select on dba_tables TO FODATA;
  939. GRANT select on v_$sess_io TO FODATA;
  940. GRANT select on v_$statname TO FODATA;
  941. GRANT select on v_$sql TO FODATA;
  942. GRANT select on v_$sysstat TO FODATA;
  943.  
  944. ALTER USER FODATA
  945. QUOTA UNLIMITED ON v8conf
  946. QUOTA UNLIMITED ON v8index
  947. QUOTA UNLIMITED ON v8large
  948. QUOTA UNLIMITED ON v8main;
  949.  
  950. grant dba to FODATA;
  951.  
  952. ==================================EXPORT=======================================
  953.  
  954. ° Data Export (EXP.EXE)
  955.  
  956. CREATE OR REPLACE TRIGGER system.LoginOnSchemaTrigger
  957. AFTER LOGON ON system.schema
  958. BEGIN
  959. EXECUTE IMMEDIATE
  960. 'ALTER SESSION SET optimizer_goal=CHOOSE';
  961. END;
  962. /
  963.  
  964. CREATE OR REPLACE TRIGGER system.LoginOnDBTrigger
  965. AFTER LOGON ON DATABASE
  966. BEGIN
  967. EXECUTE IMMEDIATE
  968. 'ALTER SESSION SET optimizer_goal=CHOOSE';
  969. END;
  970. /
  971.  
  972. ---
  973.  
  974. CD /D d:\temp
  975. SET NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
  976. EXP "system/oracle@v8" owner=v8live buffer=1024000 file=v8live.dmp log=v8live-export.log consistent=y rows=y grants=y statistics=none
  977.  
  978. ==================================IMPORT========================================
  979.  
  980. ° FIDELIO V8 option: Create tables for V8 instance
  981.  
  982. SQL*Plus
  983.  
  984. CREATE OR REPLACE TRIGGER system.LoginOnSchemaTrigger
  985. AFTER LOGON ON system.schema
  986. BEGIN
  987. EXECUTE IMMEDIATE
  988. 'ALTER SESSION SET optimizer_mode=CHOOSE';
  989. END;
  990. /
  991.  
  992. CREATE OR REPLACE TRIGGER system.LoginOnDBTrigger
  993. AFTER LOGON ON DATABASE
  994. BEGIN
  995. EXECUTE IMMEDIATE
  996. 'ALTER SESSION SET optimizer_mode=CHOOSE';
  997. END;
  998. /
  999.  
  1000. ---
  1001.  
  1002. CD /D e:\temp
  1003. SET NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
  1004. IMP "system/oracle@v8" fromuser=v8live touser=v8live buffer=2048000 file=v8live.dmp log=v8live-import.log statistics=none
  1005.  
  1006. EXECUTE sys.dbms_stats.gather_schema_stats(ownname=> 'V8LIVE' , cascade=> TRUE);
  1007.  
  1008. ---
  1009.  
  1010. CONNECT / as sysdba
  1011.  
  1012. SELECT 'ALTER '||OBJECT_TYPE||' '||OWNER||'.'||OBJECT_NAME||' COMPILE;'
  1013. FROM DBA_OBJECTS
  1014. WHERE STATUS = 'INVALID' AND OBJECT_TYPE <>'PACKAGE BODY'
  1015. AND OWNER LIKE 'V8%'
  1016. UNION
  1017. SELECT 'ALTER PACKAGE '||OWNER||'.'||OBJECT_NAME||' COMPILE BODY;'
  1018. FROM DBA_OBJECTS
  1019. WHERE STATUS = 'INVALID' AND OBJECT_TYPE ='PACKAGE BODY'
  1020. AND OWNER LIKE 'V8%';
  1021.  
  1022. SET PAGESIZE 0
  1023. SPOOL compile_invalid_objects.sql
  1024. /
  1025. SPOOL OFF
  1026. @compile_invalid_objects.sql
  1027. @compile_invalid_objects.sql
  1028.  
  1029. SET PAGESIZE 12
  1030. HOST DEL compile_invalid_objects.sql
  1031.  
  1032. ---
  1033.  
  1034. CONNECT v8live/live@v8
  1035.  
  1036. SET HEADING OFF
  1037. SET PAGESIZE 0
  1038.  
  1039. SELECT 'ALTER TABLE'||' '||table_name||' '||'MONITORING;'
  1040. FROM user_tables
  1041. WHERE tablespace_name LIKE 'V8%' ;
  1042. SPOOL run_monitoring.sql;
  1043. /
  1044. SPOOL OFF
  1045. SPOOL run_monitoring.txt
  1046. @run_monitoring.sql
  1047. SPOOL OFF
  1048. HOST DEL run_monitoring.sql
  1049. -- HOST DEL run_monitoring.txt
  1050.  
  1051. ---
  1052.  
  1053. CONNECT v8live/live@v8
  1054.  
  1055. SET LINE 100
  1056. SET LINESIZE 100
  1057. COLUMN table_name FORMAT a40
  1058. COLUMN tablespace_name FORMAT a15
  1059. COLUMN monitoring FORMAT a10
  1060. COLUMN last_analyzed_date FORMAT a20
  1061. SELECT
  1062. table_name, tablespace_name, monitoring,
  1063. TO_CHAR(last_analyzed, 'DD.MM.YYYY, HH24:MM:SS') AS last_analyzed_date
  1064. FROM user_tables
  1065. WHERE monitoring LIKE 'NO' AND tablespace_name LIKE 'V8%';
  1066.  
  1067. ============================CPU===============================================
  1068.  
  1069. -- If you have ONE CPU in your system
  1070.  
  1071. ALTER SYSTEM SET log_buffer = 131072 SCOPE=SPFILE;
  1072.  
  1073. -- If you have TWO (2) CPU's in your system
  1074.  
  1075. ALTER SYSTEM SET log_buffer = 262144 SCOPE=SPFILE;
  1076.  
  1077. -- If you have THREE (3) CPU's in your system
  1078.  
  1079. ALTER SYSTEM SET log_buffer = 393216 SCOPE=SPFILE;
  1080.  
  1081. -- If you have MORE THAN THREE (>3) CPU's in your system
  1082.  
  1083. ALTER SYSTEM SET log_buffer = 524288 SCOPE=SPFILE;
  1084.  
  1085. ==============================================================================
  1086.  
  1087. -- 1 Gbyte RAM memory
  1088.  
  1089. ALTER SYSTEM SET sga_max_size = 640M SCOPE=SPFILE;
  1090. ALTER SYSTEM SET sga_target = 640M SCOPE=SPFILE;
  1091. ALTER SYSTEM SET shared_pool_size = 300M SCOPE=SPFILE;
  1092. ALTER SYSTEM SET large_pool_size = 28 SCOPE=SPFILE;
  1093. ALTER SYSTEM SET pga_aggregate_target = 128M SCOPE=SPFILE;
  1094. ALTER SYSTEM SET processes = 30 SCOPE=SPFILE;
  1095. ALTER SYSTEM SET sessions = 40 SCOPE=SPFILE;
  1096.  
  1097. -- 2 Gbyte RAM memory V8 & DCFP
  1098.  
  1099. ALTER SYSTEM SET sga_max_size = 1428M SCOPE=SPFILE;
  1100. ALTER SYSTEM SET sga_target = 1428M SCOPE=SPFILE;
  1101. ALTER SYSTEM SET shared_pool_size = 512M SCOPE=SPFILE;
  1102. ALTER SYSTEM SET large_pool_size = 56M SCOPE=SPFILE;
  1103. ALTER SYSTEM SET pga_aggregate_target = 256M SCOPE=SPFILE;
  1104. ALTER SYSTEM SET processes = 100 SCOPE=SPFILE;
  1105. ALTER SYSTEM SET sessions = 117 SCOPE=SPFILE;
  1106.  
  1107. -- 2 Gbyte RAM memory V8 Only
  1108.  
  1109. ALTER SYSTEM SET sga_max_size = 1484M SCOPE=SPFILE;
  1110. ALTER SYSTEM SET sga_target = 1484M SCOPE=SPFILE;
  1111. ALTER SYSTEM SET shared_pool_size = 512M SCOPE=SPFILE;
  1112. ALTER SYSTEM SET large_pool_size = 56M SCOPE=SPFILE;
  1113. ALTER SYSTEM SET pga_aggregate_target = 256M SCOPE=SPFILE;
  1114. ALTER SYSTEM SET processes = 100 SCOPE=SPFILE;
  1115. ALTER SYSTEM SET sessions = 117 SCOPE=SPFILE;
  1116.  
  1117. -- 3 Gbyte RAM memory V8 & DCFP
  1118.  
  1119. ALTER SYSTEM SET sga_max_size = 1484M SCOPE=SPFILE;
  1120. ALTER SYSTEM SET sga_target = 1484M SCOPE=SPFILE;
  1121. ALTER SYSTEM SET shared_pool_size = 700M SCOPE=SPFILE;
  1122. ALTER SYSTEM SET large_pool_size = 64M SCOPE=SPFILE;
  1123. ALTER SYSTEM SET pga_aggregate_target = 256M SCOPE=SPFILE;
  1124. ALTER SYSTEM SET processes = 150 SCOPE=SPFILE;
  1125. ALTER SYSTEM SET sessions = 172 SCOPE=SPFILE;
  1126.  
  1127. -- 3 Gbyte RAM memory V8 Only
  1128.  
  1129. ALTER SYSTEM SET sga_max_size = 2150M SCOPE=SPFILE;
  1130. ALTER SYSTEM SET sga_target = 2150M SCOPE=SPFILE;
  1131. ALTER SYSTEM SET shared_pool_size = 700M SCOPE=SPFILE;
  1132. ALTER SYSTEM SET large_pool_size = 100M SCOPE=SPFILE;
  1133. ALTER SYSTEM SET pga_aggregate_target = 784M SCOPE=SPFILE;
  1134. ALTER SYSTEM SET processes = 300 SCOPE=SPFILE;
  1135. ALTER SYSTEM SET sessions = 337 SCOPE=SPFILE;
  1136.  
  1137. -- more than 3 Gbyte RAM memory V8 & DCFP
  1138.  
  1139. ALTER SYSTEM SET sga_max_size = 1843M SCOPE=SPFILE;
  1140. ALTER SYSTEM SET sga_target = 1843M SCOPE=SPFILE;
  1141. ALTER SYSTEM SET shared_pool_size = 650M SCOPE=SPFILE;
  1142. ALTER SYSTEM SET large_pool_size = 95M SCOPE=SPFILE;
  1143. ALTER SYSTEM SET pga_aggregate_target = 512M SCOPE=SPFILE;
  1144. ALTER SYSTEM SET processes = 300 SCOPE=SPFILE;
  1145. ALTER SYSTEM SET sessions = 337 SCOPE=SPFILE;
  1146.  
  1147. -- more than 3 Gbyte RAM memory V8 Only
  1148.  
  1149. ALTER SYSTEM SET sga_max_size = 2328M SCOPE=SPFILE;
  1150. ALTER SYSTEM SET sga_target = 2328M SCOPE=SPFILE;
  1151. ALTER SYSTEM SET shared_pool_size = 750M SCOPE=SPFILE;
  1152. ALTER SYSTEM SET large_pool_size = 110M SCOPE=SPFILE;
  1153. ALTER SYSTEM SET pga_aggregate_target = 848M SCOPE=SPFILE;
  1154. ALTER SYSTEM SET processes = 390 SCOPE=SPFILE;
  1155. ALTER SYSTEM SET sessions = 432 SCOPE=SPFILE;
  1156.  
  1157. -- 8 Gbyte RAM memory x64 V8 Only
  1158.  
  1159. ALTER SYSTEM SET sga_max_size = 5870M SCOPE=SPFILE;
  1160. ALTER SYSTEM SET sga_target = 5870M SCOPE=SPFILE;
  1161. ALTER SYSTEM SET shared_pool_size = 1536M SCOPE=SPFILE;
  1162. ALTER SYSTEM SET large_pool_size = 512M SCOPE=SPFILE;
  1163. ALTER SYSTEM SET pga_aggregate_target = 1772M SCOPE=SPFILE;
  1164. ALTER SYSTEM SET processes = 780 SCOPE=SPFILE;
  1165. ALTER SYSTEM SET sessions = 864 SCOPE=SPFILE;
  1166.  
  1167.  
  1168. == User Rechte in V8 Live und Train =========================================
  1169.  
  1170. select * from v$sgainfo;
  1171.  
  1172. -- V8Live
  1173.  
  1174. grant select on v_$session to v8live;
  1175. grant select on v_$parameter to v8live;
  1176. grant select on v_$database to v8live;
  1177. grant select on v_$instance to v8live;
  1178.  
  1179. -- V8Train
  1180.  
  1181. grant select on v_$session to v8train;
  1182. grant select on v_$parameter to v8train;
  1183. grant select on v_$database to v8train;
  1184. grant select on v_$instance to v8train;
  1185.  
  1186. ==============================================================================
  1187.  
  1188. ° Archive mode
  1189. ° Steps to switch on the archive mode
  1190.  
  1191. ALTER SYSTEM SET log_archive_start = TRUE SCOPE=spfile;
  1192. ALTER SYSTEM SET log_archive_dest_1 = 'LOCATION=USE_DB_RECOVERY_FILE_DEST' SCOPE=spfile;
  1193. ALTER SYSTEM SET log_archive_format = 'ARC%S_%R.%T' SCOPE=spfile;
  1194. shutdown immediate
  1195.  
  1196. STARTUP MOUNT
  1197.  
  1198. ALTER DATABASE ARCHIVELOG;
  1199. ALTER DATABASE OPEN;
  1200. ALTER SYSTEM ARCHIVE LOG START;
  1201.  
  1202. ARCHIVE LOG LIST
  1203.  
  1204. ==============================================================================
  1205.  
  1206. ° Steps to switch off the archive mode
  1207.  
  1208. SQL*Plus
  1209.  
  1210. SHUTDOWN IMMEDIATE
  1211. STARTUP MOUNT
  1212.  
  1213. ALTER DATABASE NOARCHIVELOG;
  1214. ALTER DATABASE OPEN;
  1215. ALTER SYSTEM ARCHIVE LOG START;
  1216.  
  1217. ARCHIVE LOG LIST
  1218.  
  1219. ==============================================================================
  1220.  
  1221. --Add Datafile to OMF
  1222.  
  1223. ALTER TABLESPACE <TABLESPACENAME> ADD DATAFILE SIZE 1024M
  1224. AUTOEXTEND ON NEXT 1024M
  1225. MAXSIZE 10240M;
  1226.  
  1227. ==============================================================================
  1228.  
  1229. ---Reconfig OEM
  1230.  
  1231. set oracle_sid=V8
  1232.  
  1233. emctl stop dbconsole
  1234. emca -deconfig dbcontrol db
  1235. emca -repos recreate
  1236. emca -config dbcontrol db -DBCONTROL_HTTP_PORT 1158
  1237.  
  1238. ---Restart Server
  1239.  
  1240. ---java.lang.Exception: Exception in sending Request :: null > ---After this error in OEM Restart Server is a Timezone Problem
  1241.  
  1242. ==============================================================================
  1243. Steps to Recover DB using RMAN:
  1244. -------------------------------
  1245.  
  1246. 1.:
  1247. oradim -new -sid V8 -intpwd oracle -startmode a
  1248.  
  1249. (Change for the Service OracleServiceV8 the USer settings Geisel-Hotels\Backup.Rman PW: Oracle.03)
  1250.  
  1251. 2.: cd to database folder: cd c:\oracle\10.2.0\database\database
  1252. orapwd file=PwdV8.ora entries=5 password=oracle
  1253.  
  1254. 3.:
  1255. cmd
  1256. set ORACLE_SID=V8
  1257.  
  1258. 4.: CD to E:\backup.rman
  1259. get DATABASE ID from backup files
  1260.  
  1261. Example:
  1262. Filename = CF_C-3320001944-20080130-1F
  1263. Database ID = 3320001944
  1264.  
  1265. 5.:
  1266. rman NOCATALOG
  1267.  
  1268. set dbid=3345852456
  1269.  
  1270. 6.:
  1271. connect target sys/oracle@v8 [---> MAKE SURE THE ORA LISTENER IS UP AND RUNNING !!!]
  1272.  
  1273. 7.:
  1274. startup force nomount
  1275.  
  1276.  
  1277. 8.:
  1278. host 'copy \\192.168.178.3\Backup.Rman\O1_MF_SYSDUAL*.DBF E:\ORACLE\oradata\v8\DATAFILE\O1_MF_SYSDUAL*.DBF';
  1279. host 'copy \\192.168.178.3\Backup.Rman\INITV8.ORA C:\ORACLE\10.2.0\DATABASE\database\INITV8.ORA';
  1280.  
  1281.  
  1282. 9.: [---> SET IP ADDRESS AS APPROPRIATE !!!!!]
  1283.  
  1284. SQL "CREATE SPFILE FROM pfile";
  1285.  
  1286. wait 3 minute
  1287.  
  1288. 10.:
  1289. restore controlfile from '\\192.168.178.3\Backup.Rman\CF_C-3345852456-20090107-2A'; <-- Last Controlefile CF_C-%DBID%... oder SNAPCF_V8.F
  1290.  
  1291. 11.:
  1292. run
  1293. {
  1294. alter database mount;
  1295. restore database check readonly;
  1296. recover database noredo;
  1297. }
  1298.  
  1299. 12.:
  1300. recover database noredo;
  1301.  
  1302. 13.:
  1303. alter database open resetlogs;
  1304.  
  1305. 14.:
  1306. recover database;
  1307.  
  1308. 15.:
  1309. run
  1310. {
  1311. set until scn 6186099;
  1312. recover database;
  1313. }
  1314.  
  1315. 16.:
  1316. alter database open resetlogs;
  1317.  
  1318. 17.:
  1319. sqlplus "sys/oracle@v8 as sysdba"
  1320.  
  1321.  
  1322. 18.:
  1323. Check Temporary Tablespaces
  1324.  
  1325. select name,bytes from v$tempfile;
  1326.  
  1327. Wenn OK:
  1328.  
  1329. NAME
  1330. ---------------------------------------------------------
  1331.  
  1332. BYTES
  1333. ----------
  1334. E:\ORACLE\ORADATA\V8\DATAFILE\O1_MF_TEMP_4PB420ST_.TMP
  1335. 20971520
  1336.  
  1337. E:\ORACLE\ORADATA\V8\DATAFILE\O1_MF_V8TEMP_4PB420ST_.TMP
  1338. 2147483648
  1339.  
  1340. E:\ORACLE\ORADATA\V8\DATAFILE\O1_MF_MCTEMP_4PB420T9_.TMP
  1341. 268435456
  1342.  
  1343.  
  1344. Sonst neu erzeugen
  1345.  
  1346. CREATE SMALLFILE TEMPORARY TABLESPACE mftemp
  1347. TEMPFILE SIZE 256M
  1348. AUTOEXTEND ON NEXT 256M MAXSIZE 1024M
  1349. EXTENT MANAGEMENT LOCAL
  1350. UNIFORM SIZE 1024K;
  1351.  
  1352.  
  1353. CREATE SMALLFILE TEMPORARY TABLESPACE v8temp
  1354. TEMPFILE SIZE 2G REUSE
  1355. AUTOEXTEND ON NEXT 1G MAXSIZE 10G
  1356. EXTENT MANAGEMENT LOCAL
  1357. UNIFORM SIZE 1024;
  1358.  
  1359. ==============================================================================
  1360.  
  1361. ---Reconfig OEM
  1362.  
  1363. set oracle_sid=V8
  1364.  
  1365. emctl stop dbconsole
  1366. emca -deconfig dbcontrol db
  1367. emca -repos recreate
  1368. emca -config dbcontrol db -DBCONTROL_HTTP_PORT 1158
  1369.  
  1370. ---Restart Server
  1371.  
  1372. ---java.lang.Exception: Exception in sending Request :: null > ---After this error in OEM Restart Server is a Timezone Problem
  1373.  
  1374. ==============================================================================
  1375.  
  1376. Nach Server reboot wenn die Datenbank nicht automatisch gesteartet ist
  1377.  
  1378. startup nomount
  1379.  
  1380. SHOW PARAMETERS control_files
  1381.  
  1382. ControleFile Namen mit den Namen aus der Abfrage vergleichen ggf. ändern
  1383.  
  1384. alter database mount;
  1385.  
  1386. alter database open;
  1387.  
  1388. ------------------------------------------------------------------------------
  1389.  
  1390. ENDE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!