trd@trdro1:~>ssh db01 Linux db01 2.6.8-2-386 #1 Tue Aug 16 12:46:35 UTC 2005 i686 GNU/Linux The programs included with the Debian GNU/Linux system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. Last login: Wed Jul 26 17:09:59 2006 from dietel.trd.net ----------------------------------------------------- trd@db01:~>rlfe sqlplus alice/alice123@db01:1522/play SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 26 18:28:16 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& SQL> select table_name from user_tables; TABLE_NAME ------------------------------ CFDAT_CONFIG CFDAT_SCRIPT CFDAT_CONFIG_SCRIPTS CFDAT_COMMAND CFDAT_TAG DCS_ALIAS ROC_SUMMARY SERVICENAMES HVSERVICENAMES ROB_ERROR_CODES ROB_ERROR TABLE_NAME ------------------------------ BENCHMARK_TABLE SM ROC ROB &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& SQL> describe roc Name Null? Type ----------------------------------------- -------- ---------------------------- ROC_TYPE NOT NULL CHAR(4) ROC_SERIAL NOT NULL NUMBER DCS_ID NUMBER SM_ID NUMBER SM_STACK NUMBER SM_LAYER NUMBER &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& SQL> select * from roc; ROC_ ROC_SERIAL DCS_ID SM_ID SM_STACK SM_LAYER ---- ---------- ---------- ---------- ---------- ---------- L1C1 19 426 L1C0 17 402 L1C1 2 530 L1C0 8 532 L1C1 11 531 L1C1 20 422 L2C1 3 407 L5C0 1 414 L3C1 23 405 L4C1 3 416 L4C1 4 418 ROC_ ROC_SERIAL DCS_ID SM_ID SM_STACK SM_LAYER ---- ---------- ---------- ---------- ---------- ---------- L4C1 11 415 L2C0 5 410 L0C1 2 423 L0C1 4 529 L2C1 1 408 L2C1 5 411 L2C1 18 409 L3C1 21 406 L3C1 17 400 L4C0 18 533 L4C1 8 428 ROC_ ROC_SERIAL DCS_ID SM_ID SM_STACK SM_LAYER ---- ---------- ---------- ---------- ---------- ---------- L5C1 4 427 L5C1 34 429 L3C0 8 412 L5C1 35 419 L5C1 3 421 L3C1 31 L0C0 15 525 1 2 0 L0C1 1 527 1 3 0 L0C1 3 526 1 4 0 31 rows selected. &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& SQL> select * from dcs_alias; DCS_ID SM STACK LAYER ---------- ---------- ---------- ---------- 422 2 0 1 402 2 0 2 38 2 3 0 1002 2 1 0 44 2 2 0 532 2 0 0 &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& SQL> select * from feeservers; SERVERNAME SM STACK LAYER ---------------------- ---------- ---------- ---------- trd_dimfeeserver_0525 1 2 0 trd_dimfeeserver_0527 1 3 0 trd_dimfeeserver_0526 1 4 0 trd_dimfeeserver_0422 2 0 1 trd_dimfeeserver_0402 2 0 2 trd_dimfeeserver_0038 2 3 0 trd_dimfeeserver_1002 2 1 0 trd_dimfeeserver_0044 2 2 0 trd_dimfeeserver_0532 2 0 0 9 rows selected. &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& SQL> select * from services; . . SERVICE -------------------------------------------------------------------------------- trd_dimfeeserver_1002_CHANNEL_ONOFF_00003 trd_dimfeeserver_1002_CHANNEL_ONOFF_00004 trd_dimfeeserver_1002_CHANNEL_ONOFF_00005 trd_dimfeeserver_1002_CHANNEL_ONOFF_00010 trd_dimfeeserver_1002_CHANNEL_ONOFF_00011 trd_dimfeeserver_1002_CHANNEL_ONOFF_00012 trd_dimfeeserver_1002_CHANNEL_ONOFF_00013 trd_dimfeeserver_1002_CHANNEL_ONOFF_00014 trd_dimfeeserver_1002_CHANNEL_ONOFF_00015 trd_dimfeeserver_1002_STATUS_DES_U_00001 trd_dimfeeserver_1002_STATUS_DES_U_00000 SERVICE -------------------------------------------------------------------------------- trd_dimfeeserver_1002_STATUS_DES_U_00002 trd_dimfeeserver_1002_STATUS_DES_U_00003 trd_dimfeeserver_1002_STATUS_DES_U_00004 trd_dimfeeserver_1002_STATUS_DES_U_00005 trd_dimfeeserver_1002_STATUS_DES_U_00010 trd_dimfeeserver_1002_STATUS_DES_U_00011 trd_dimfeeserver_1002_STATUS_DES_U_00012 trd_dimfeeserver_1002_STATUS_DES_U_00013 trd_dimfeeserver_1002_STATUS_DES_U_00014 trd_dimfeeserver_1002_STATUS_DES_U_00015 . . &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& SQL> select * from servicenames; SERVICENAME -------------------------------------------------------------------------------- Command Acknowledge Message AdcChannel01 dataPoint01 dataPoint02 dataPoint03 dataPoint04 &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& SQL> select view_name from user_views; VIEW_NAME ------------------------------ FEESERVERS SERVICES &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& more info --------- gateDB server is alice00 wingDB contains several more configurations on trdro1 --------- /home/trd/dietel/wingDB gate2wing : update several tables from gateDB to wingDB (ROC, ROB) &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& trd@trdro1:~/dietel/wingDB>wing_dcsalias usage: wing_dcsalias ls wing_dcsalias add dcsXXXX :: wing_dcsalias rm :: wing_dcsalias rm dcsXXXX trd@trdro1:~/dietel/wingDB>wing_dcsalias ls dcs0422 -> 2:0:1 dcs0402 -> 2:0:2 dcs0038 -> 2:3:0 dcs1002 -> 2:1:0 dcs0044 -> 2:2:0 dcs0532 -> 2:0:0 &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& references) ----------- http://www.ss64.com/ora/ http://www.psoug.org/reference/select.html http://www.cs.wisc.edu/~dbbook/openAccess/thirdEdition/Oracle/user_guide/oracle_guide.html#Tables http://www-db.stanford.edu/~ullman/fcdb/oracle/or-intro.html#0.1_inserting+tuples http://www.psoug.org/reference/views.html