Guest User

Untitled

a guest
Sep 7th, 2012
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.92 KB | None | 0 0
  1. 0: jdbc:luciddb:http://localhost> select * from sys_root.DBA_SCHEMAS ;
  2. +---------------+---------------------+----------+------------------------+----+
  3.  
  4. | CATALOG_NAME | SCHEMA_NAME | CREATOR | CREATION_TIMESTAMP | LA |
  5.  
  6. +---------------+---------------------+----------+------------------------+----+
  7.  
  8. | SYS_BOOT | SYS_BOOT | sa | 2011-10-03 04:28:59.0 | 20 |
  9.  
  10. | LOCALDB | SQLJ | sa | 2011-10-03 04:29:08.0 | 20 |
  11.  
  12. | SYS_BOOT | JDBC_METADATA | sa | 2011-10-03 04:29:11.0 | 20 |
  13.  
  14. | LOCALDB | INFORMATION_SCHEMA | sa | 2011-10-03 04:29:23.0 | 20 |
  15.  
  16. | SYS_BOOT | MGMT | sa | 2011-10-03 04:29:25.0 | 20 |
  17.  
  18. | LOCALDB | APPLIB | sa | 2011-10-03 04:30:16.0 | 20 |
  19.  
  20. | LOCALDB | SYS_ROOT | sa | 2011-10-03 04:30:43.0 | 20 |
  21.  
  22. | LOCALDB | MYANALYTICS | sa | 2012-06-16 16:30:14.0 | 20 |
  23.  
  24. +---------------+---------------------+----------+------------------------+----+
  25.  
  26.  
  27.  
  28. 0: jdbc:luciddb:http://localhost> select * from sys_root.dba_stored_tables;
  29. +---------------+-----------------+----------------+-----------------+---------+
  30.  
  31. | CATALOG_NAME | SCHEMA_NAME | TABLE_NAME | CREATOR | CREAT |
  32.  
  33. +---------------+-----------------+----------------+-----------------+---------+
  34.  
  35. | LOCALDB | MYANALYTICS | DIM_CUSTOMER | MYANALYTICS | 2012-06 |
  36.  
  37. | LOCALDB | MYANALYTICS | DIM_WEBSTORE | MYANALYTICS | 2012-06 |
  38.  
  39. | LOCALDB | MYANALYTICS | DIM_PROMOTION | MYANALYTICS | 2012-06 |
  40.  
  41. | LOCALDB | MYANALYTICS | DIM_DATE | MYANALYTICS | 2012-06 |
  42.  
  43. | LOCALDB | MYANALYTICS | DIM_PRODUCT | MYANALYTICS | 2012-06 |
  44.  
  45. | LOCALDB | MYANALYTICS | FACT_SALES | MYANALYTICS | 2012-07 |
  46.  
  47. +---------------+-----------------+----------------+-----------------+---------+
Advertisement
Add Comment
Please, Sign In to add comment