Lin Hong's TECH Blog! 刀不磨要生锈,人不学习要落后 - Thinking ahead

Oracle 23c Free rpm install Tips

2023-04-11

Oracle 23c Free rpm install Tips

Vagrant Install

% git clone https://github.com/shakiyam/vagrant-oracle-database-23c-free.git
 Download rpm
vagrant up

Download : oracle-database-free-23c-1.0-1.el8.x86_64.rpm

[vagrant@localhost ~]$ sqlplus system/oracle

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Tue Apr 11 03:27:33 2023
Version 23.2.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.

Last Successful login time: Tue Apr 11 2023 03:27:14 +00:00

Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0

SQL> select 2023+4;

    2023+4
----------
      2027

SQL> 

Logs

honglin@honglin-mac vagrant-oracle-database-23c-free % vagrant up
Bringing machine 'default' up with 'virtualbox' provider...
==> default: Importing base box 'oraclelinux/8'...
==> default: Matching MAC address for NAT networking...
==> default: Checking if box 'oraclelinux/8' version '8.6.359' is up to date...
==> default: A newer version of the box 'oraclelinux/8' for provider 'virtualbox' is
==> default: available! You currently have version '8.6.359'. The latest is version
==> default: '8.7.411'. Run `vagrant box update` to update.
==> default: Setting the name of the VM: vagrant-oracle-database-23c-free_default_1681181964246_59400
==> default: Clearing any previously set network interfaces...
==> default: Preparing network interfaces based on configuration...
    default: Adapter 1: nat
==> default: Forwarding ports...
    default: 1521 (guest) => 1521 (host) (adapter 1)
    default: 22 (guest) => 2222 (host) (adapter 1)
==> default: Booting VM...
==> default: Waiting for machine to boot. This may take a few minutes...
    default: SSH address: 127.0.0.1:2222
    default: SSH username: vagrant
    default: SSH auth method: private key
==> default: Machine booted and ready!
==> default: Checking for guest additions in VM...
    default: The guest additions on this VM do not match the installed version of
    default: VirtualBox! In most cases this is fine, but in rare cases it can
    default: prevent things such as shared folders from working properly. If you see
    default: shared folder errors, please make sure the guest additions within the
    default: virtual machine match the version of VirtualBox you have installed on
    default: your host and reload your VM.
    default: 
    default: Guest Additions Version: 6.1.34 r150636
    default: VirtualBox Version: 7.0
==> default: Mounting shared folders...
    default: /vagrant => /Users/honglin/01_VMs/vagrant-oracle-database-23c-free
==> default: Running provisioner: shell...
    default: Running: /var/folders/lk/1hs380qn16b5tlrcys4zdqw80000gn/T/vagrant-shell20230411-39979-1uf1hmy.sh
    default: Environment file .env not found. Therefore, dotenv.sample will be used.
    default: /vagrant/oracle-database-free-23c-1.0-1.el8.x86_64.rpm: OK
    default: Oracle Linux 8 BaseOS Latest (x86_64)            16 MB/s |  57 MB     00:03
    default: Oracle Linux 8 Application Stream (x86_64)       13 MB/s |  43 MB     00:03
    default: Latest Unbreakable Enterprise Kernel Release 6   17 MB/s |  65 MB     00:03
    default: Last metadata expiration check: 0:00:10 ago on Tue 11 Apr 2023 03:00:37 AM UTC.
    default: Dependencies resolved.
    default: ================================================================================
    default:  Package                            Arch    Version    Repository          Size
    default: ================================================================================
    default: Installing:
    default:  oraclelinux-developer-release-el8  x86_64  1.0-7.el8  ol8_baseos_latest   16 k
    default: 
    default: Transaction Summary
    default: ================================================================================
    default: Install  1 Package
    default: 
    default: Total download size: 16 k
    default: Installed size: 18 k
    default: Downloading Packages:
    default: oraclelinux-developer-release-el8-1.0-7.el8.x86  37 kB/s |  16 kB     00:00
    default: --------------------------------------------------------------------------------
    default: Total                                            37 kB/s |  16 kB     00:00
    default: Running transaction check
    default: Transaction check succeeded.
    default: Running transaction test
    default: Transaction test succeeded.
    default: Running transaction
    default:   Preparing        :                                                        1/1
    default:   Installing       : oraclelinux-developer-release-el8-1.0-7.el8.x86_64     1/1
    default:   Verifying        : oraclelinux-developer-release-el8-1.0-7.el8.x86_64     1/1
    default: 
    default: Installed:
    default:   oraclelinux-developer-release-el8-1.0-7.el8.x86_64
    default: 
    default: Complete!
    default: Oracle Linux 8 Development Packages (x86_64)     16 MB/s |  80 MB     00:04
    default: Last metadata expiration check: 0:00:24 ago on Tue 11 Apr 2023 03:00:57 AM UTC.
    default: Dependencies resolved.
    default: ==================================================================================================
    default:  Package                          Arch    Version                         Repository          Size
    default: ==================================================================================================
    default: Installing:
    default:  oracle-database-free-23c         x86_64  1.0-1                           @commandline       1.6 G
    default: Installing dependencies:
    default:  bc                               x86_64  1.07.1-5.el8                    ol8_baseos_latest  129 k
    default:  bind-libs                        x86_64  32:9.11.36-5.el8_7.2            ol8_appstream      175 k
    default:  bind-libs-lite                   x86_64  32:9.11.36-5.el8_7.2            ol8_appstream      1.2 M
    default:  bind-license                     noarch  32:9.11.36-5.el8_7.2            ol8_appstream      104 k
    default:  bind-utils                       x86_64  32:9.11.36-5.el8_7.2            ol8_appstream      452 k
    default:  checkpolicy                      x86_64  2.9-1.el8                       ol8_baseos_latest  346 k
    default:  compat-openssl10                 x86_64  1:1.0.2o-4.el8_6                ol8_appstream      1.1 M
    default:  fstrm                            x86_64  0.6.1-3.el8                     ol8_appstream       29 k
    default:  gssproxy                         x86_64  0.8.0-21.el8                    ol8_baseos_latest  119 k
    default:  keyutils                         x86_64  1.5.10-9.el8                    ol8_baseos_latest   66 k
    default:  ksh                              x86_64  20120801-257.0.1.el8            ol8_appstream      929 k
    default:  libICE                           x86_64  1.0.9-15.el8                    ol8_appstream       74 k
    default:  libSM                            x86_64  1.2.3-1.el8                     ol8_appstream       47 k
    default:  libX11                           x86_64  1.6.8-5.el8                     ol8_appstream      611 k
    default:  libX11-common                    noarch  1.6.8-5.el8                     ol8_appstream      158 k
    default:  libX11-xcb                       x86_64  1.6.8-5.el8                     ol8_appstream       14 k
    default:  libXau                           x86_64  1.0.9-3.el8                     ol8_appstream       37 k
    default:  libXcomposite                    x86_64  0.4.4-14.el8                    ol8_appstream       28 k
    default:  libXext                          x86_64  1.3.4-1.el8                     ol8_appstream       45 k
    default:  libXi                            x86_64  1.7.10-1.el8                    ol8_appstream       49 k
    default:  libXinerama                      x86_64  1.1.4-1.el8                     ol8_appstream       15 k
    default:  libXmu                           x86_64  1.1.3-1.el8                     ol8_appstream       75 k
    default:  libXrandr                        x86_64  1.5.2-1.el8                     ol8_appstream       34 k
    default:  libXrender                       x86_64  0.9.10-7.el8                    ol8_appstream       33 k
    default:  libXt                            x86_64  1.1.5-12.el8                    ol8_appstream      185 k
    default:  libXtst                          x86_64  1.2.3-7.el8                     ol8_appstream       22 k
    default:  libXv                            x86_64  1.0.11-7.el8                    ol8_appstream       20 k
    default:  libXxf86dga                      x86_64  1.1.5-1.el8                     ol8_appstream       26 k
    default:  libXxf86misc                     x86_64  1.0.4-1.el8                     ol8_appstream       23 k
    default:  libXxf86vm                       x86_64  1.1.4-9.el8                     ol8_appstream       19 k
    default:  libbasicobjects                  x86_64  0.1.1-40.el8                    ol8_baseos_latest   31 k
    default:  libcollection                    x86_64  0.7.0-40.el8                    ol8_baseos_latest   48 k
    default:  libdmx                           x86_64  1.1.4-3.el8                     ol8_appstream       22 k
    default:  libini_config                    x86_64  1.3.1-40.el8                    ol8_baseos_latest   70 k
    default:  libmaxminddb                     x86_64  1.2.0-10.el8                    ol8_appstream       33 k
    default:  libnfsidmap                      x86_64  1:2.3.3-57.el8_7.1              ol8_baseos_latest  122 k
    default:  libnsl                           x86_64  2.28-189.5.0.1.el8_6            ol8_baseos_latest  103 k
    default:  libpath_utils                    x86_64  0.2.1-40.el8                    ol8_baseos_latest   34 k
    default:  libref_array                     x86_64  0.1.5-40.el8                    ol8_baseos_latest   33 k
    default:  libverto-libevent                x86_64  0.3.0-5.el8                     ol8_baseos_latest   16 k
    default:  libxcb                           x86_64  1.13.1-1.el8                    ol8_appstream      231 k
    default:  lm_sensors-libs                  x86_64  3.4.0-23.20180522git70f7e08.el8 ol8_baseos_latest   59 k
    default:  net-tools                        x86_64  2.0-0.52.20160912git.el8        ol8_baseos_latest  322 k
    default:  nfs-utils                        x86_64  1:2.3.3-57.el8_7.1              ol8_baseos_latest  515 k
    default:  oracle-database-preinstall-23c   x86_64  1.0-0.5.el8                     ol8_developer       30 k
    default:  policycoreutils-python-utils     noarch  2.9-19.0.1.el8                  ol8_baseos_latest  253 k
    default:  protobuf-c                       x86_64  1.3.0-6.el8                     ol8_appstream       37 k
    default:  python3-audit                    x86_64  3.0.7-2.el8.2                   ol8_baseos_latest   87 k
    default:  python3-bind                     noarch  32:9.11.36-5.el8_7.2            ol8_appstream      151 k
    default:  python3-libsemanage              x86_64  2.9-8.el8                       ol8_baseos_latest  128 k
    default:  python3-ply                      noarch  3.9-9.el8                       ol8_baseos_latest  111 k
    default:  python3-policycoreutils          noarch  2.9-19.0.1.el8                  ol8_baseos_latest  2.2 M
    default:  python3-pyyaml                   x86_64  5.4.1-1.0.1.el8                 ol8_developer      205 k
    default:  python3-setools                  x86_64  4.3.0-3.el8                     ol8_baseos_latest  624 k
    default:  quota                            x86_64  1:4.04-14.el8                   ol8_baseos_latest  214 k
    default:  quota-nls                        noarch  1:4.04-14.el8                   ol8_baseos_latest   95 k
    default:  rpcbind                          x86_64  1.2.5-10.el8                    ol8_baseos_latest   70 k
    default:  smartmontools                    x86_64  1:7.1-1.el8                     ol8_baseos_latest  544 k
    default:  sysstat                          x86_64  11.7.3-7.0.1.el8_7.1            ol8_appstream      426 k
    default:  unzip                            x86_64  6.0-46.0.1.el8                  ol8_baseos_latest  196 k
    default:  xorg-x11-utils                   x86_64  7.5-28.el8                      ol8_appstream      136 k
    default:  xorg-x11-xauth                   x86_64  1:1.0.9-12.el8                  ol8_appstream       39 k
    default: Installing weak dependencies:
    default:  geolite2-city                    noarch  20180605-1.el8                  ol8_appstream       19 M
    default:  geolite2-country                 noarch  20180605-1.el8                  ol8_appstream      1.0 M
    default: 
    default: Transaction Summary
    default: ==================================================================================================
    default: Install  65 Packages
    default: 
    default: Total size: 1.7 G
    default: Total download size: 33 M
    default: Installed size: 5.3 G
    default: Downloading Packages:
    default: (1/64): bc-1.07.1-5.el8.x86_64.rpm              234 kB/s | 129 kB     00:00
    default: (2/64): gssproxy-0.8.0-21.el8.x86_64.rpm        209 kB/s | 119 kB     00:00
    default: (3/64): keyutils-1.5.10-9.el8.x86_64.rpm        904 kB/s |  66 kB     00:00
    default: (4/64): checkpolicy-2.9-1.el8.x86_64.rpm        540 kB/s | 346 kB     00:00
    default: (5/64): libbasicobjects-0.1.1-40.el8.x86_64.rpm 433 kB/s |  31 kB     00:00
    default: (6/64): libcollection-0.7.0-40.el8.x86_64.rpm   656 kB/s |  48 kB     00:00
    default: (7/64): libini_config-1.3.1-40.el8.x86_64.rpm   978 kB/s |  70 kB     00:00
    default: (8/64): libnsl-2.28-189.5.0.1.el8_6.x86_64.rpm  1.3 MB/s | 103 kB     00:00
    default: (9/64): libnfsidmap-2.3.3-57.el8_7.1.x86_64.rpm 890 kB/s | 122 kB     00:00
    default: (10/64): libpath_utils-0.2.1-40.el8.x86_64.rpm  481 kB/s |  34 kB     00:00
    default: (11/64): libref_array-0.1.5-40.el8.x86_64.rpm   431 kB/s |  33 kB     00:00
    default: (12/64): lm_sensors-libs-3.4.0-23.20180522git70 778 kB/s |  59 kB     00:00
    default: (13/64): libverto-libevent-0.3.0-5.el8.x86_64.r 166 kB/s |  16 kB     00:00
    default: (14/64): net-tools-2.0-0.52.20160912git.el8.x86 2.2 MB/s | 322 kB     00:00
    default: (15/64): nfs-utils-2.3.3-57.el8_7.1.x86_64.rpm  3.3 MB/s | 515 kB     00:00
    default: (16/64): policycoreutils-python-utils-2.9-19.0. 1.7 MB/s | 253 kB     00:00
    default: (17/64): python3-audit-3.0.7-2.el8.2.x86_64.rpm 1.1 MB/s |  87 kB     00:00
    default: (18/64): python3-libsemanage-2.9-8.el8.x86_64.r 1.7 MB/s | 128 kB     00:00
    default: (19/64): python3-ply-3.9-9.el8.noarch.rpm       1.4 MB/s | 111 kB     00:00
    default: (20/64): python3-setools-4.3.0-3.el8.x86_64.rpm 5.9 MB/s | 624 kB     00:00
    default: (21/64): quota-4.04-14.el8.x86_64.rpm           2.0 MB/s | 214 kB     00:00
    default: (22/64): quota-nls-4.04-14.el8.noarch.rpm       1.3 MB/s |  95 kB     00:00
    default: (23/64): rpcbind-1.2.5-10.el8.x86_64.rpm        977 kB/s |  70 kB     00:00
    default: (24/64): python3-policycoreutils-2.9-19.0.1.el8 9.0 MB/s | 2.2 MB     00:00
    default: (25/64): smartmontools-7.1-1.el8.x86_64.rpm     5.3 MB/s | 544 kB     00:00
    default: (26/64): bind-libs-9.11.36-5.el8_7.2.x86_64.rpm 2.3 MB/s | 175 kB     00:00
    default: (27/64): unzip-6.0-46.0.1.el8.x86_64.rpm        1.1 MB/s | 196 kB     00:00
    default: (28/64): bind-libs-lite-9.11.36-5.el8_7.2.x86_6  11 MB/s | 1.2 MB     00:00
    default: (29/64): bind-license-9.11.36-5.el8_7.2.noarch. 1.2 MB/s | 104 kB     00:00
    default: (30/64): bind-utils-9.11.36-5.el8_7.2.x86_64.rp 5.1 MB/s | 452 kB     00:00
    default: (31/64): fstrm-0.6.1-3.el8.x86_64.rpm           345 kB/s |  29 kB     00:00
    default: (32/64): compat-openssl10-1.0.2o-4.el8_6.x86_64 9.5 MB/s | 1.1 MB     00:00
    default: (33/64): geolite2-country-20180605-1.el8.noarch 8.5 MB/s | 1.0 MB     00:00
    default: (34/64): ksh-20120801-257.0.1.el8.x86_64.rpm    5.5 MB/s | 929 kB     00:00
    default: (35/64): libICE-1.0.9-15.el8.x86_64.rpm         596 kB/s |  74 kB     00:00
    default: (36/64): libSM-1.2.3-1.el8.x86_64.rpm           460 kB/s |  47 kB     00:00
    default: (37/64): libX11-1.6.8-5.el8.x86_64.rpm          3.9 MB/s | 611 kB     00:00
    default: (38/64): libX11-common-1.6.8-5.el8.noarch.rpm   1.3 MB/s | 158 kB     00:00
    default: (39/64): libX11-xcb-1.6.8-5.el8.x86_64.rpm      138 kB/s |  14 kB     00:00
    default: (40/64): libXau-1.0.9-3.el8.x86_64.rpm          385 kB/s |  37 kB     00:00
    default: (41/64): libXcomposite-0.4.4-14.el8.x86_64.rpm  228 kB/s |  28 kB     00:00
    default: (42/64): libXext-1.3.4-1.el8.x86_64.rpm         414 kB/s |  45 kB     00:00
    default: (43/64): libXi-1.7.10-1.el8.x86_64.rpm          554 kB/s |  49 kB     00:00
    default: (44/64): libXinerama-1.1.4-1.el8.x86_64.rpm     179 kB/s |  15 kB     00:00
    default: (45/64): libXmu-1.1.3-1.el8.x86_64.rpm          680 kB/s |  75 kB     00:00
    default: (46/64): libXrandr-1.5.2-1.el8.x86_64.rpm       302 kB/s |  34 kB     00:00
    default: (47/64): geolite2-city-20180605-1.el8.noarch.rp  19 MB/s |  19 MB     00:01
    default: (48/64): libXrender-0.9.10-7.el8.x86_64.rpm     215 kB/s |  33 kB     00:00
    default: (49/64): libXt-1.1.5-12.el8.x86_64.rpm          1.2 MB/s | 185 kB     00:00
    default: (50/64): libXtst-1.2.3-7.el8.x86_64.rpm         307 kB/s |  22 kB     00:00
    default: (51/64): libXv-1.0.11-7.el8.x86_64.rpm          268 kB/s |  20 kB     00:00
    default: (52/64): libXxf86dga-1.1.5-1.el8.x86_64.rpm     356 kB/s |  26 kB     00:00
    default: (53/64): libXxf86misc-1.0.4-1.el8.x86_64.rpm    322 kB/s |  23 kB     00:00
    default: (54/64): libXxf86vm-1.1.4-9.el8.x86_64.rpm      273 kB/s |  19 kB     00:00
    default: (55/64): libdmx-1.1.4-3.el8.x86_64.rpm          308 kB/s |  22 kB     00:00
    default: (56/64): libmaxminddb-1.2.0-10.el8.x86_64.rpm   433 kB/s |  33 kB     00:00
    default: (57/64): libxcb-1.13.1-1.el8.x86_64.rpm         2.9 MB/s | 231 kB     00:00
    default: (58/64): protobuf-c-1.3.0-6.el8.x86_64.rpm      499 kB/s |  37 kB     00:00
    default: (59/64): python3-bind-9.11.36-5.el8_7.2.noarch. 1.9 MB/s | 151 kB     00:00
    default: (60/64): sysstat-11.7.3-7.0.1.el8_7.1.x86_64.rp 4.4 MB/s | 426 kB     00:00
    default: (61/64): xorg-x11-utils-7.5-28.el8.x86_64.rpm   1.4 MB/s | 136 kB     00:00
    default: (62/64): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm 488 kB/s |  39 kB     00:00
    default: (63/64): oracle-database-preinstall-23c-1.0-0.5 412 kB/s |  30 kB     00:00
    default: (64/64): python3-pyyaml-5.4.1-1.0.1.el8.x86_64. 2.6 MB/s | 205 kB     00:00
    default: --------------------------------------------------------------------------------
    default: Total                                            11 MB/s |  33 MB     00:02
    default: Running transaction check
    default: Transaction check succeeded.
    default: Running transaction test
    default: Transaction test succeeded.
    default: Running transaction
    default:   Preparing        :                                                        1/1
    default:   Installing       : protobuf-c-1.3.0-6.el8.x86_64                         1/65
    default:   Installing       : fstrm-0.6.1-3.el8.x86_64                              2/65
    default:   Installing       : bind-license-32:9.11.36-5.el8_7.2.noarch              3/65
    default:   Installing       : libXau-1.0.9-3.el8.x86_64                             4/65
    default:   Installing       : libxcb-1.13.1-1.el8.x86_64                            5/65
    default:   Installing       : libICE-1.0.9-15.el8.x86_64                            6/65
    default:   Installing       : net-tools-2.0-0.52.20160912git.el8.x86_64             7/65
    default:   Running scriptlet: net-tools-2.0-0.52.20160912git.el8.x86_64             7/65
    default:   Installing       : libref_array-0.1.5-40.el8.x86_64                      8/65
    default:   Installing       : libcollection-0.7.0-40.el8.x86_64                     9/65
    default:   Installing       : libbasicobjects-0.1.1-40.el8.x86_64                  10/65
    default:   Installing       : libSM-1.2.3-1.el8.x86_64                             11/65
    default:   Installing       : python3-pyyaml-5.4.1-1.0.1.el8.x86_64                12/65
    default:   Installing       : libX11-xcb-1.6.8-5.el8.x86_64                        13/65
    default:   Installing       : libX11-common-1.6.8-5.el8.noarch                     14/65
    default:   Installing       : libX11-1.6.8-5.el8.x86_64                            15/65
    default:   Installing       : libXext-1.3.4-1.el8.x86_64                           16/65
    default:   Installing       : libXi-1.7.10-1.el8.x86_64                            17/65
    default:   Installing       : libXrender-0.9.10-7.el8.x86_64                       18/65
    default:   Installing       : libXrandr-1.5.2-1.el8.x86_64                         19/65
    default:   Installing       : libXtst-1.2.3-7.el8.x86_64                           20/65
    default:   Installing       : libXinerama-1.1.4-1.el8.x86_64                       21/65
    default:   Installing       : libXv-1.0.11-7.el8.x86_64                            22/65
    default:   Installing       : libXxf86dga-1.1.5-1.el8.x86_64                       23/65
    default:   Installing       : libXxf86misc-1.0.4-1.el8.x86_64                      24/65
    default:   Installing       : libXxf86vm-1.1.4-9.el8.x86_64                        25/65
    default:   Installing       : libdmx-1.1.4-3.el8.x86_64                            26/65
    default:   Installing       : libXcomposite-0.4.4-14.el8.x86_64                    27/65
    default:   Installing       : xorg-x11-utils-7.5-28.el8.x86_64                     28/65
    default:   Installing       : libXt-1.1.5-12.el8.x86_64                            29/65
    default:   Installing       : libXmu-1.1.3-1.el8.x86_64                            30/65
    default:   Installing       : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                 31/65
    default:   Installing       : ksh-20120801-257.0.1.el8.x86_64                      32/65
    default:   Running scriptlet: ksh-20120801-257.0.1.el8.x86_64                      32/65
    default:   Installing       : geolite2-country-20180605-1.el8.noarch               33/65
    default:   Installing       : geolite2-city-20180605-1.el8.noarch                  34/65
    default:   Installing       : libmaxminddb-1.2.0-10.el8.x86_64                     35/65
    default:   Running scriptlet: libmaxminddb-1.2.0-10.el8.x86_64                     35/65
    default:   Installing       : bind-libs-lite-32:9.11.36-5.el8_7.2.x86_64           36/65
    default:   Installing       : bind-libs-32:9.11.36-5.el8_7.2.x86_64                37/65
    default:   Installing       : compat-openssl10-1:1.0.2o-4.el8_6.x86_64             38/65
    default:   Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64             38/65
    default:   Installing       : unzip-6.0-46.0.1.el8.x86_64                          39/65
    default:   Running scriptlet: smartmontools-1:7.1-1.el8.x86_64                     40/65
    default:   Installing       : smartmontools-1:7.1-1.el8.x86_64                     40/65
    default:   Running scriptlet: smartmontools-1:7.1-1.el8.x86_64                     40/65
    default:   Running scriptlet: rpcbind-1.2.5-10.el8.x86_64                          41/65
    default:   Installing       : rpcbind-1.2.5-10.el8.x86_64                          41/65
    default:   Running scriptlet: rpcbind-1.2.5-10.el8.x86_64                          41/65
    default:   Installing       : quota-nls-1:4.04-14.el8.noarch                       42/65
    default:   Installing       : quota-1:4.04-14.el8.x86_64                           43/65
    default:   Installing       : python3-setools-4.3.0-3.el8.x86_64                   44/65
    default:   Installing       : python3-ply-3.9-9.el8.noarch                         45/65
    default:   Installing       : python3-bind-32:9.11.36-5.el8_7.2.noarch             46/65
    default:   Installing       : bind-utils-32:9.11.36-5.el8_7.2.x86_64               47/65
    default:   Installing       : python3-libsemanage-2.9-8.el8.x86_64                 48/65
    default:   Installing       : python3-audit-3.0.7-2.el8.2.x86_64                   49/65
    default:   Installing       : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x8   50/65
    default:   Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x8   50/65
    default:   Installing       : sysstat-11.7.3-7.0.1.el8_7.1.x86_64                  51/65
    default:   Running scriptlet: sysstat-11.7.3-7.0.1.el8_7.1.x86_64                  51/65
    default:   Installing       : libverto-libevent-0.3.0-5.el8.x86_64                 52/65
    default:   Installing       : libpath_utils-0.2.1-40.el8.x86_64                    53/65
    default:   Installing       : libini_config-1.3.1-40.el8.x86_64                    54/65
    default:   Installing       : gssproxy-0.8.0-21.el8.x86_64                         55/65
    default:   Running scriptlet: gssproxy-0.8.0-21.el8.x86_64                         55/65
    default:   Installing       : libnsl-2.28-189.5.0.1.el8_6.x86_64                   56/65
    default:   Installing       : libnfsidmap-1:2.3.3-57.el8_7.1.x86_64                57/65
    default:   Installing       : keyutils-1.5.10-9.el8.x86_64                         58/65
    default:   Running scriptlet: nfs-utils-1:2.3.3-57.el8_7.1.x86_64                  59/65
    default:   Installing       : nfs-utils-1:2.3.3-57.el8_7.1.x86_64                  59/65
    default:   Running scriptlet: nfs-utils-1:2.3.3-57.el8_7.1.x86_64                  59/65
    default:   Installing       : checkpolicy-2.9-1.el8.x86_64                         60/65
    default:   Installing       : python3-policycoreutils-2.9-19.0.1.el8.noarch        61/65
    default:   Installing       : policycoreutils-python-utils-2.9-19.0.1.el8.noarch   62/65
    default:   Installing       : bc-1.07.1-5.el8.x86_64                               63/65
    default:   Running scriptlet: bc-1.07.1-5.el8.x86_64                               63/65
    default:   Installing       : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64    64/65
    default:   Verifying        : oracle-database-free-23c-1.0-1.x86_64                65/65
    default: 
    default: Installed:
    default:   bc-1.07.1-5.el8.x86_64
    default:   bind-libs-32:9.11.36-5.el8_7.2.x86_64
    default:   bind-libs-lite-32:9.11.36-5.el8_7.2.x86_64
    default:   bind-license-32:9.11.36-5.el8_7.2.noarch
    default:   bind-utils-32:9.11.36-5.el8_7.2.x86_64
    default:   checkpolicy-2.9-1.el8.x86_64
    default:   compat-openssl10-1:1.0.2o-4.el8_6.x86_64
    default:   fstrm-0.6.1-3.el8.x86_64
    default:   geolite2-city-20180605-1.el8.noarch
    default:   geolite2-country-20180605-1.el8.noarch
    default:   gssproxy-0.8.0-21.el8.x86_64
    default:   keyutils-1.5.10-9.el8.x86_64
    default:   ksh-20120801-257.0.1.el8.x86_64
    default:   libICE-1.0.9-15.el8.x86_64
    default:   libSM-1.2.3-1.el8.x86_64
    default:   libX11-1.6.8-5.el8.x86_64
    default:   libX11-common-1.6.8-5.el8.noarch
    default:   libX11-xcb-1.6.8-5.el8.x86_64
    default:   libXau-1.0.9-3.el8.x86_64
    default:   libXcomposite-0.4.4-14.el8.x86_64
    default:   libXext-1.3.4-1.el8.x86_64
    default:   libXi-1.7.10-1.el8.x86_64
    default:   libXinerama-1.1.4-1.el8.x86_64
    default:   libXmu-1.1.3-1.el8.x86_64
    default:   libXrandr-1.5.2-1.el8.x86_64
    default:   libXrender-0.9.10-7.el8.x86_64
    default:   libXt-1.1.5-12.el8.x86_64
    default:   libXtst-1.2.3-7.el8.x86_64
    default:   libXv-1.0.11-7.el8.x86_64
    default:   libXxf86dga-1.1.5-1.el8.x86_64
    default:   libXxf86misc-1.0.4-1.el8.x86_64
    default:   libXxf86vm-1.1.4-9.el8.x86_64
    default:   libbasicobjects-0.1.1-40.el8.x86_64
    default:   libcollection-0.7.0-40.el8.x86_64
    default:   libdmx-1.1.4-3.el8.x86_64
    default:   libini_config-1.3.1-40.el8.x86_64
    default:   libmaxminddb-1.2.0-10.el8.x86_64
    default:   libnfsidmap-1:2.3.3-57.el8_7.1.x86_64
    default:   libnsl-2.28-189.5.0.1.el8_6.x86_64
    default:   libpath_utils-0.2.1-40.el8.x86_64
    default:   libref_array-0.1.5-40.el8.x86_64
    default:   libverto-libevent-0.3.0-5.el8.x86_64
    default:   libxcb-1.13.1-1.el8.x86_64
    default:   lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64
    default:   net-tools-2.0-0.52.20160912git.el8.x86_64
    default:   nfs-utils-1:2.3.3-57.el8_7.1.x86_64
    default:   oracle-database-free-23c-1.0-1.x86_64
    default:   oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
    default:   policycoreutils-python-utils-2.9-19.0.1.el8.noarch
    default:   protobuf-c-1.3.0-6.el8.x86_64
    default:   python3-audit-3.0.7-2.el8.2.x86_64
    default:   python3-bind-32:9.11.36-5.el8_7.2.noarch
    default:   python3-libsemanage-2.9-8.el8.x86_64
    default:   python3-ply-3.9-9.el8.noarch
    default:   python3-policycoreutils-2.9-19.0.1.el8.noarch
    default:   python3-pyyaml-5.4.1-1.0.1.el8.x86_64
    default:   python3-setools-4.3.0-3.el8.x86_64
    default:   quota-1:4.04-14.el8.x86_64
    default:   quota-nls-1:4.04-14.el8.noarch
    default:   rpcbind-1.2.5-10.el8.x86_64
    default:   smartmontools-1:7.1-1.el8.x86_64
    default:   sysstat-11.7.3-7.0.1.el8_7.1.x86_64
    default:   unzip-6.0-46.0.1.el8.x86_64
    default:   xorg-x11-utils-7.5-28.el8.x86_64
    default:   xorg-x11-xauth-1:1.0.9-12.el8.x86_64
    default: 
    default: Complete!
    default: Configuring Oracle Listener.
    default: Listener configuration succeeded.
    default: Configuring Oracle Database FREE.
    default: Enter SYS user password:
    default: ***** 
    default: Enter SYSTEM user password:
    default: ******
    default: Enter PDBADMIN User Password:
    default: *******
    default: Prepare for db operation
    default: 7% complete
    default: Copying database files
    default: 29% complete
    default: Creating and starting Oracle instance
    default: 30% complete
    default: 33% complete
    default: 36% complete
    default: 39% complete
    default: 43% complete
    default: Completing Database Creation
    default: 47% complete
    default: 49% complete
    default: 50% complete
    default: Creating Pluggable Databases
    default: 54% complete
    default: 71% complete
    default: Executing Post Configuration Actions
    default: 93% complete
    default: Running Custom Scripts
    default: 100% complete
    default: Database creation complete. For details check the logfiles at:
    default:  /opt/oracle/cfgtoollogs/dbca/FREE.
    default: Database Information:
    default: Global Database Name:FREE
    default: System Identifier(SID):FREE
    default: Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details.
    default: 
    default: Connect to Oracle Database using one of the connect strings:
    default:      Pluggable database: localhost.localdomain/FREEPDB1
    default:      Multitenant container database: localhost.localdomain
    default: Last metadata expiration check: 0:12:17 ago on Tue 11 Apr 2023 03:00:57 AM UTC.
    default: Dependencies resolved.
    default: ================================================================================
    default:  Package                  Arch    Version              Repository          Size
    default: ================================================================================
    default: Installing:
    default:  oracle-epel-release-el8  x86_64  1.0-5.el8            ol8_baseos_latest   15 k
    default: Installing dependencies:
    default:  yum-utils                noarch  4.0.21-11.0.1.el8    ol8_baseos_latest   74 k
    default: 
    default: Transaction Summary
    default: ================================================================================
    default: Install  2 Packages
    default: 
    default: Total download size: 89 k
    default: Installed size: 41 k
    default: Downloading Packages:
    default: (1/2): oracle-epel-release-el8-1.0-5.el8.x86_64  40 kB/s |  15 kB     00:00
    default: (2/2): yum-utils-4.0.21-11.0.1.el8.noarch.rpm    46 kB/s |  74 kB     00:01
    default: --------------------------------------------------------------------------------
    default: Total                                            56 kB/s |  89 kB     00:01
    default: Running transaction check
    default: Transaction check succeeded.
    default: Running transaction test
    default: Transaction test succeeded.
    default: Running transaction
    default:   Preparing        :                                                        1/1
    default:   Installing       : yum-utils-4.0.21-11.0.1.el8.noarch                     1/2
    default:   Installing       : oracle-epel-release-el8-1.0-5.el8.x86_64               2/2
    default:   Running scriptlet: oracle-epel-release-el8-1.0-5.el8.x86_64               2/2
    default:   Verifying        : oracle-epel-release-el8-1.0-5.el8.x86_64               1/2
    default:   Verifying        : yum-utils-4.0.21-11.0.1.el8.noarch                     2/2
    default: 
    default: Installed:
    default:   oracle-epel-release-el8-1.0-5.el8.x86_64  yum-utils-4.0.21-11.0.1.el8.noarch
    default: 
    default: Complete!
    default: Oracle Linux 8 EPEL Packages for Development (x  14 MB/s |  44 MB     00:03
    default: Oracle Linux 8 EPEL Modular Packages for Develo 355 kB/s | 322 kB     00:00
    default: Dependencies resolved.
    default: ===================================================================================================
    default:  Package                  Arch    Version                                 Repository           Size
    default: ===================================================================================================
    default: Installing:
    default:  rlwrap                   x86_64  0.46.1-1.el8                            ol8_developer_EPEL  140 k
    default: Installing dependencies:
    default:  perl-Carp                noarch  1.42-396.el8                            ol8_baseos_latest    30 k
    default:  perl-Data-Dumper         x86_64  2.167-399.el8                           ol8_baseos_latest    58 k
    default:  perl-Digest              noarch  1.17-395.el8                            ol8_appstream        27 k
    default:  perl-Digest-MD5          x86_64  2.55-396.el8                            ol8_appstream        37 k
    default:  perl-Encode              x86_64  4:2.97-3.el8                            ol8_baseos_latest   1.5 M
    default:  perl-Errno               x86_64  1.28-421.el8                            ol8_baseos_latest    76 k
    default:  perl-Exporter            noarch  5.72-396.el8                            ol8_baseos_latest    34 k
    default:  perl-File-Path           noarch  2.15-2.el8                              ol8_baseos_latest    38 k
    default:  perl-File-Slurp          noarch  9999.19-19.el8                          ol8_appstream        47 k
    default:  perl-File-Temp           noarch  0.230.600-1.el8                         ol8_baseos_latest    63 k
    default:  perl-Getopt-Long         noarch  1:2.50-4.el8                            ol8_baseos_latest    63 k
    default:  perl-HTTP-Tiny           noarch  0.074-1.el8                             ol8_baseos_latest    58 k
    default:  perl-IO                  x86_64  1.38-421.el8                            ol8_baseos_latest   142 k
    default:  perl-MIME-Base64         x86_64  3.15-396.el8                            ol8_baseos_latest    31 k
    default:  perl-Net-SSLeay          x86_64  1.88-2.module+el8.6.0+20623+f0897f98    ol8_appstream       379 k
    default:  perl-PathTools           x86_64  3.74-1.el8                              ol8_baseos_latest    90 k
    default:  perl-Pod-Escapes         noarch  1:1.07-395.el8                          ol8_baseos_latest    20 k
    default:  perl-Pod-Perldoc         noarch  3.28-396.el8                            ol8_baseos_latest    88 k
    default:  perl-Pod-Simple          noarch  1:3.35-395.el8                          ol8_baseos_latest   213 k
    default:  perl-Pod-Usage           noarch  4:1.69-395.el8                          ol8_baseos_latest    34 k
    default:  perl-Scalar-List-Utils   x86_64  3:1.49-2.el8                            ol8_baseos_latest    68 k
    default:  perl-Socket              x86_64  4:2.027-3.el8                           ol8_baseos_latest    59 k
    default:  perl-Storable            x86_64  1:3.11-3.el8                            ol8_baseos_latest    98 k
    default:  perl-Term-ANSIColor      noarch  4.06-396.el8                            ol8_baseos_latest    46 k
    default:  perl-Term-Cap            noarch  1.17-395.el8                            ol8_baseos_latest    23 k
    default:  perl-Text-ParseWords     noarch  3.30-395.el8                            ol8_baseos_latest    18 k
    default:  perl-Text-Tabs+Wrap      noarch  2013.0523-395.el8                       ol8_baseos_latest    24 k
    default:  perl-Time-Local          noarch  1:1.280-1.el8                           ol8_baseos_latest    33 k
    default:  perl-URI                 noarch  1.73-3.el8                              ol8_appstream       116 k
    default:  perl-Unicode-Normalize   x86_64  1.25-396.el8                            ol8_baseos_latest    82 k
    default:  perl-constant            noarch  1.33-396.el8                            ol8_baseos_latest    25 k
    default:  perl-interpreter         x86_64  4:5.26.3-421.el8                        ol8_baseos_latest   6.3 M
    default:  perl-libnet              noarch  3.11-3.el8                              ol8_appstream       121 k
    default:  perl-libs                x86_64  4:5.26.3-421.el8                        ol8_baseos_latest   1.6 M
    default:  perl-macros              x86_64  4:5.26.3-421.el8                        ol8_baseos_latest    72 k
    default:  perl-parent              noarch  1:0.237-1.el8                           ol8_baseos_latest    20 k
    default:  perl-podlators           noarch  4.11-1.el8                              ol8_baseos_latest   118 k
    default:  perl-threads             x86_64  1:2.21-2.el8                            ol8_baseos_latest    61 k
    default:  perl-threads-shared      x86_64  1.58-2.el8                              ol8_baseos_latest    48 k
    default:  python3-pip              noarch  9.0.3-22.el8                            ol8_appstream        20 k
    default:  python3-setuptools       noarch  39.2.0-6.el8                            ol8_baseos_latest   163 k
    default:  python36                 x86_64  3.6.8-38.module+el8.5.0+20329+5c5719bc  ol8_appstream        19 k
    default: Installing weak dependencies:
    default:  perl-IO-Socket-IP        noarch  0.39-5.el8                              ol8_appstream        47 k
    default:  perl-IO-Socket-SSL       noarch  2.066-4.module+el8.6.0+20623+f0897f98   ol8_appstream       298 k
    default:  perl-Mozilla-CA          noarch  20160104-7.module+el8.3.0+7692+542c56f9 ol8_appstream        15 k
    default: Enabling module streams:
    default:  perl                             5.26
    default:  perl-IO-Socket-SSL               2.066
    default:  perl-libwww-perl                 6.34
    default:  python36                         3.6
    default: 
    default: Transaction Summary
    default: ===================================================================================================
    default: Install  46 Packages
    default: 
    default: Total download size: 13 M
    default: Installed size: 36 M
    default: Downloading Packages:
    default: (1/46): perl-Carp-1.42-396.el8.noarch.rpm        74 kB/s |  30 kB     00:00
    default: (2/46): perl-Data-Dumper-2.167-399.el8.x86_64.r 122 kB/s |  58 kB     00:00
    default: (3/46): rlwrap-0.46.1-1.el8.x86_64.rpm          270 kB/s | 140 kB     00:00
    default: (4/46): perl-Exporter-5.72-396.el8.noarch.rpm   486 kB/s |  34 kB     00:00
    default: (5/46): perl-Errno-1.28-421.el8.x86_64.rpm      554 kB/s |  76 kB     00:00
    default: (6/46): perl-File-Path-2.15-2.el8.noarch.rpm    506 kB/s |  38 kB     00:00
    default: (7/46): perl-File-Temp-0.230.600-1.el8.noarch.r 875 kB/s |  63 kB     00:00
    default: (8/46): perl-Getopt-Long-2.50-4.el8.noarch.rpm  857 kB/s |  63 kB     00:00
    default: (9/46): perl-HTTP-Tiny-0.074-1.el8.noarch.rpm   777 kB/s |  58 kB     00:00
    default: (10/46): perl-Encode-2.97-3.el8.x86_64.rpm      3.7 MB/s | 1.5 MB     00:00
    default: (11/46): perl-IO-1.38-421.el8.x86_64.rpm        1.8 MB/s | 142 kB     00:00
    default: (12/46): perl-MIME-Base64-3.15-396.el8.x86_64.r 436 kB/s |  31 kB     00:00
    default: (13/46): perl-PathTools-3.74-1.el8.x86_64.rpm   1.2 MB/s |  90 kB     00:00
    default: (14/46): perl-Pod-Escapes-1.07-395.el8.noarch.r 294 kB/s |  20 kB     00:00
    default: (15/46): perl-Pod-Perldoc-3.28-396.el8.noarch.r 1.1 MB/s |  88 kB     00:00
    default: (16/46): perl-Pod-Simple-3.35-395.el8.noarch.rp 2.6 MB/s | 213 kB     00:00
    default: (17/46): perl-Pod-Usage-1.69-395.el8.noarch.rpm 430 kB/s |  34 kB     00:00
    default: (18/46): perl-Scalar-List-Utils-1.49-2.el8.x86_ 928 kB/s |  68 kB     00:00
    default: (19/46): perl-Socket-2.027-3.el8.x86_64.rpm     778 kB/s |  59 kB     00:00
    default: (20/46): perl-Storable-3.11-3.el8.x86_64.rpm    1.2 MB/s |  98 kB     00:00
    default: (21/46): perl-Term-ANSIColor-4.06-396.el8.noarc 663 kB/s |  46 kB     00:00
    default: (22/46): perl-Term-Cap-1.17-395.el8.noarch.rpm  329 kB/s |  23 kB     00:00
    default: (23/46): perl-Text-ParseWords-3.30-395.el8.noar 265 kB/s |  18 kB     00:00
    default: (24/46): perl-Text-Tabs+Wrap-2013.0523-395.el8. 344 kB/s |  24 kB     00:00
    default: (25/46): perl-Time-Local-1.280-1.el8.noarch.rpm 443 kB/s |  33 kB     00:00
    default: (26/46): perl-Unicode-Normalize-1.25-396.el8.x8 1.1 MB/s |  82 kB     00:00
    default: (27/46): perl-constant-1.33-396.el8.noarch.rpm  338 kB/s |  25 kB     00:00
    default: (28/46): perl-macros-5.26.3-421.el8.x86_64.rpm  712 kB/s |  72 kB     00:00
    default: (29/46): perl-parent-0.237-1.el8.noarch.rpm     168 kB/s |  20 kB     00:00
    default: (30/46): perl-podlators-4.11-1.el8.noarch.rpm   834 kB/s | 118 kB     00:00
    default: (31/46): perl-libs-5.26.3-421.el8.x86_64.rpm    3.7 MB/s | 1.6 MB     00:00
    default: (32/46): perl-interpreter-5.26.3-421.el8.x86_64  13 MB/s | 6.3 MB     00:00
    default: (33/46): perl-threads-2.21-2.el8.x86_64.rpm     683 kB/s |  61 kB     00:00
    default: (34/46): perl-threads-shared-1.58-2.el8.x86_64. 664 kB/s |  48 kB     00:00
    default: (35/46): python3-setuptools-39.2.0-6.el8.noarch 2.0 MB/s | 163 kB     00:00
    default: (36/46): perl-Digest-1.17-395.el8.noarch.rpm    340 kB/s |  27 kB     00:00
    default: (37/46): perl-Digest-MD5-2.55-396.el8.x86_64.rp 465 kB/s |  37 kB     00:00
    default: (38/46): perl-IO-Socket-IP-0.39-5.el8.noarch.rp 605 kB/s |  47 kB     00:00
    default: (39/46): perl-File-Slurp-9999.19-19.el8.noarch. 567 kB/s |  47 kB     00:00
    default: (40/46): perl-IO-Socket-SSL-2.066-4.module+el8. 3.5 MB/s | 298 kB     00:00
    default: (41/46): perl-Mozilla-CA-20160104-7.module+el8. 228 kB/s |  15 kB     00:00
    default: (42/46): perl-URI-1.73-3.el8.noarch.rpm         1.6 MB/s | 116 kB     00:00
    default: (43/46): perl-Net-SSLeay-1.88-2.module+el8.6.0+ 2.7 MB/s | 379 kB     00:00
    default: (44/46): perl-libnet-3.11-3.el8.noarch.rpm      1.5 MB/s | 121 kB     00:00
    default: (45/46): python3-pip-9.0.3-22.el8.noarch.rpm    291 kB/s |  20 kB     00:00
    default: (46/46): python36-3.6.8-38.module+el8.5.0+20329  84 kB/s |  19 kB     00:00
    default: --------------------------------------------------------------------------------
    default: Total                                           5.6 MB/s |  13 MB     00:02
    default: Running transaction check
    default: Transaction check succeeded.
    default: Running transaction test
    default: Transaction test succeeded.
    default: Running transaction
    default:   Preparing        :                                                        1/1
    default:   Installing       : perl-Digest-1.17-395.el8.noarch                       1/46
    default:   Installing       : perl-Digest-MD5-2.55-396.el8.x86_64                   2/46
    default:   Installing       : perl-Data-Dumper-2.167-399.el8.x86_64                 3/46
    default:   Installing       : perl-libnet-3.11-3.el8.noarch                         4/46
    default:   Installing       : perl-Net-SSLeay-1.88-2.module+el8.6.0+20623+f0897f    5/46
    default:   Installing       : perl-URI-1.73-3.el8.noarch                            6/46
    default:   Installing       : perl-Pod-Escapes-1:1.07-395.el8.noarch                7/46
    default:   Installing       : perl-Time-Local-1:1.280-1.el8.noarch                  8/46
    default:   Installing       : perl-IO-Socket-IP-0.39-5.el8.noarch                   9/46
    default:   Installing       : perl-Mozilla-CA-20160104-7.module+el8.3.0+7692+542   10/46
    default:   Installing       : perl-IO-Socket-SSL-2.066-4.module+el8.6.0+20623+f0   11/46
    default:   Installing       : perl-Term-ANSIColor-4.06-396.el8.noarch              12/46
    default:   Installing       : perl-Term-Cap-1.17-395.el8.noarch                    13/46
    default:   Installing       : perl-File-Temp-0.230.600-1.el8.noarch                14/46
    default:   Installing       : perl-Pod-Simple-1:3.35-395.el8.noarch                15/46
    default:   Installing       : perl-HTTP-Tiny-0.074-1.el8.noarch                    16/46
    default:   Installing       : perl-podlators-4.11-1.el8.noarch                     17/46
    default:   Installing       : perl-Pod-Perldoc-3.28-396.el8.noarch                 18/46
    default:   Installing       : perl-Text-ParseWords-3.30-395.el8.noarch             19/46
    default:   Installing       : perl-Pod-Usage-4:1.69-395.el8.noarch                 20/46
    default:   Installing       : perl-MIME-Base64-3.15-396.el8.x86_64                 21/46
    default:   Installing       : perl-Storable-1:3.11-3.el8.x86_64                    22/46
    default:   Installing       : perl-Getopt-Long-1:2.50-4.el8.noarch                 23/46
    default:   Installing       : perl-Errno-1.28-421.el8.x86_64                       24/46
    default:   Installing       : perl-Socket-4:2.027-3.el8.x86_64                     25/46
    default:   Installing       : perl-Encode-4:2.97-3.el8.x86_64                      26/46
    default:   Installing       : perl-Exporter-5.72-396.el8.noarch                    27/46
    default:   Installing       : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64           28/46
    default:   Installing       : perl-macros-4:5.26.3-421.el8.x86_64                  29/46
    default:   Installing       : perl-parent-1:0.237-1.el8.noarch                     30/46
    default:   Installing       : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch         31/46
    default:   Installing       : perl-Unicode-Normalize-1.25-396.el8.x86_64           32/46
    default:   Installing       : perl-File-Path-2.15-2.el8.noarch                     33/46
    default:   Installing       : perl-IO-1.38-421.el8.x86_64                          34/46
    default:   Installing       : perl-PathTools-3.74-1.el8.x86_64                     35/46
    default:   Installing       : perl-constant-1.33-396.el8.noarch                    36/46
    default:   Installing       : perl-threads-1:2.21-2.el8.x86_64                     37/46
    default:   Installing       : perl-threads-shared-1.58-2.el8.x86_64                38/46
    default:   Installing       : perl-libs-4:5.26.3-421.el8.x86_64                    39/46
    default:   Installing       : perl-Carp-1.42-396.el8.noarch                        40/46
    default:   Installing       : perl-interpreter-4:5.26.3-421.el8.x86_64             41/46
    default:   Installing       : perl-File-Slurp-9999.19-19.el8.noarch                42/46
    default:   Installing       : python3-setuptools-39.2.0-6.el8.noarch               43/46
    default:   Installing       : python3-pip-9.0.3-22.el8.noarch                      44/46
    default:   Installing       : python36-3.6.8-38.module+el8.5.0+20329+5c5719bc.x8   45/46
    default:   Running scriptlet: python36-3.6.8-38.module+el8.5.0+20329+5c5719bc.x8   45/46
    default:   Installing       : rlwrap-0.46.1-1.el8.x86_64                           46/46
    default:   Running scriptlet: rlwrap-0.46.1-1.el8.x86_64                           46/46
    default:   Verifying        : rlwrap-0.46.1-1.el8.x86_64                            1/46
    default:   Verifying        : perl-Carp-1.42-396.el8.noarch                         2/46
    default:   Verifying        : perl-Data-Dumper-2.167-399.el8.x86_64                 3/46
    default:   Verifying        : perl-Encode-4:2.97-3.el8.x86_64                       4/46
    default:   Verifying        : perl-Errno-1.28-421.el8.x86_64                        5/46
    default:   Verifying        : perl-Exporter-5.72-396.el8.noarch                     6/46
    default:   Verifying        : perl-File-Path-2.15-2.el8.noarch                      7/46
    default:   Verifying        : perl-File-Temp-0.230.600-1.el8.noarch                 8/46
    default:   Verifying        : perl-Getopt-Long-1:2.50-4.el8.noarch                  9/46
    default:   Verifying        : perl-HTTP-Tiny-0.074-1.el8.noarch                    10/46
    default:   Verifying        : perl-IO-1.38-421.el8.x86_64                          11/46
    default:   Verifying        : perl-MIME-Base64-3.15-396.el8.x86_64                 12/46
    default:   Verifying        : perl-PathTools-3.74-1.el8.x86_64                     13/46
    default:   Verifying        : perl-Pod-Escapes-1:1.07-395.el8.noarch               14/46
    default:   Verifying        : perl-Pod-Perldoc-3.28-396.el8.noarch                 15/46
    default:   Verifying        : perl-Pod-Simple-1:3.35-395.el8.noarch                16/46
    default:   Verifying        : perl-Pod-Usage-4:1.69-395.el8.noarch                 17/46
    default:   Verifying        : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64           18/46
    default:   Verifying        : perl-Socket-4:2.027-3.el8.x86_64                     19/46
    default:   Verifying        : perl-Storable-1:3.11-3.el8.x86_64                    20/46
    default:   Verifying        : perl-Term-ANSIColor-4.06-396.el8.noarch              21/46
    default:   Verifying        : perl-Term-Cap-1.17-395.el8.noarch                    22/46
    default:   Verifying        : perl-Text-ParseWords-3.30-395.el8.noarch             23/46
    default:   Verifying        : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch         24/46
    default:   Verifying        : perl-Time-Local-1:1.280-1.el8.noarch                 25/46
    default:   Verifying        : perl-Unicode-Normalize-1.25-396.el8.x86_64           26/46
    default:   Verifying        : perl-constant-1.33-396.el8.noarch                    27/46
    default:   Verifying        : perl-interpreter-4:5.26.3-421.el8.x86_64             28/46
    default:   Verifying        : perl-libs-4:5.26.3-421.el8.x86_64                    29/46
    default:   Verifying        : perl-macros-4:5.26.3-421.el8.x86_64                  30/46
    default:   Verifying        : perl-parent-1:0.237-1.el8.noarch                     31/46
    default:   Verifying        : perl-podlators-4.11-1.el8.noarch                     32/46
    default:   Verifying        : perl-threads-1:2.21-2.el8.x86_64                     33/46
    default:   Verifying        : perl-threads-shared-1.58-2.el8.x86_64                34/46
    default:   Verifying        : python3-setuptools-39.2.0-6.el8.noarch               35/46
    default:   Verifying        : perl-Digest-1.17-395.el8.noarch                      36/46
    default:   Verifying        : perl-Digest-MD5-2.55-396.el8.x86_64                  37/46
    default:   Verifying        : perl-File-Slurp-9999.19-19.el8.noarch                38/46
    default:   Verifying        : perl-IO-Socket-IP-0.39-5.el8.noarch                  39/46
    default:   Verifying        : perl-IO-Socket-SSL-2.066-4.module+el8.6.0+20623+f0   40/46
    default:   Verifying        : perl-Mozilla-CA-20160104-7.module+el8.3.0+7692+542   41/46
    default:   Verifying        : perl-Net-SSLeay-1.88-2.module+el8.6.0+20623+f0897f   42/46
    default:   Verifying        : perl-URI-1.73-3.el8.noarch                           43/46
    default:   Verifying        : perl-libnet-3.11-3.el8.noarch                        44/46
    default:   Verifying        : python3-pip-9.0.3-22.el8.noarch                      45/46
    default:   Verifying        : python36-3.6.8-38.module+el8.5.0+20329+5c5719bc.x8   46/46
    default: 
    default: Installed:
    default:   perl-Carp-1.42-396.el8.noarch
    default:   perl-Data-Dumper-2.167-399.el8.x86_64
    default:   perl-Digest-1.17-395.el8.noarch
    default:   perl-Digest-MD5-2.55-396.el8.x86_64
    default:   perl-Encode-4:2.97-3.el8.x86_64
    default:   perl-Errno-1.28-421.el8.x86_64
    default:   perl-Exporter-5.72-396.el8.noarch
    default:   perl-File-Path-2.15-2.el8.noarch
    default:   perl-File-Slurp-9999.19-19.el8.noarch
    default:   perl-File-Temp-0.230.600-1.el8.noarch
    default:   perl-Getopt-Long-1:2.50-4.el8.noarch
    default:   perl-HTTP-Tiny-0.074-1.el8.noarch
    default:   perl-IO-1.38-421.el8.x86_64
    default:   perl-IO-Socket-IP-0.39-5.el8.noarch
    default:   perl-IO-Socket-SSL-2.066-4.module+el8.6.0+20623+f0897f98.noarch
    default:   perl-MIME-Base64-3.15-396.el8.x86_64
    default:   perl-Mozilla-CA-20160104-7.module+el8.3.0+7692+542c56f9.noarch
    default:   perl-Net-SSLeay-1.88-2.module+el8.6.0+20623+f0897f98.x86_64
    default:   perl-PathTools-3.74-1.el8.x86_64
    default:   perl-Pod-Escapes-1:1.07-395.el8.noarch
    default:   perl-Pod-Perldoc-3.28-396.el8.noarch
    default:   perl-Pod-Simple-1:3.35-395.el8.noarch
    default:   perl-Pod-Usage-4:1.69-395.el8.noarch
    default:   perl-Scalar-List-Utils-3:1.49-2.el8.x86_64
    default:   perl-Socket-4:2.027-3.el8.x86_64
    default:   perl-Storable-1:3.11-3.el8.x86_64
    default:   perl-Term-ANSIColor-4.06-396.el8.noarch
    default:   perl-Term-Cap-1.17-395.el8.noarch
    default:   perl-Text-ParseWords-3.30-395.el8.noarch
    default:   perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch
    default:   perl-Time-Local-1:1.280-1.el8.noarch
    default:   perl-URI-1.73-3.el8.noarch
    default:   perl-Unicode-Normalize-1.25-396.el8.x86_64
    default:   perl-constant-1.33-396.el8.noarch
    default:   perl-interpreter-4:5.26.3-421.el8.x86_64
    default:   perl-libnet-3.11-3.el8.noarch
    default:   perl-libs-4:5.26.3-421.el8.x86_64
    default:   perl-macros-4:5.26.3-421.el8.x86_64
    default:   perl-parent-1:0.237-1.el8.noarch
    default:   perl-podlators-4.11-1.el8.noarch
    default:   perl-threads-1:2.21-2.el8.x86_64
    default:   perl-threads-shared-1.58-2.el8.x86_64
    default:   python3-pip-9.0.3-22.el8.noarch
    default:   python3-setuptools-39.2.0-6.el8.noarch
    default:   python36-3.6.8-38.module+el8.5.0+20329+5c5719bc.x86_64
    default:   rlwrap-0.46.1-1.el8.x86_64
    default: 
    default: Complete!
    default: oracle-free-23c.service is not a native service, redirecting to systemd-sysv-install.
    default: Executing: /usr/lib/systemd/systemd-sysv-install enable oracle-free-23c
                                                #    -#O=- #    #                          
       #   #   #     #                                                  -=O=-              
    default: 
    default: SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Tue Apr 11 03:14:13 2023
    default: Version 23.2.0.0.0
    default: 
    default: Copyright (c) 1982, 2023, Oracle.  All rights reserved.
    default: 
    default: Last Successful login time: Tue Apr 11 2023 03:09:06 +00:00
    default: 
    default: Connected to:
    default: Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
    default: Version 23.2.0.0.0
    default: 
    default: SQL>
    default: specify password for SYSTEM as parameter 1:
    default: 
    default: specify password for SYS as parameter 2:
    default: 
    default: specify password for HR as parameter 3:
    default: 
    default: specify password for OE as parameter 4:
    default: 
    default: specify password for PM as parameter 5:
    default: 
    default: specify password for IX as parameter 6:
    default: 
    default: specify password for  SH as parameter 7:
    default: 
    default: specify password for  BI as parameter 8:
    default: 
    default: specify default tablespace as parameter 9:
    default: 
    default: specify temporary tablespace as parameter 10:
    default: 
    default: specify log file directory (including trailing delimiter) as parameter 11:
    default: 
    default: specify connect string as parameter 12:
    default: 
    default: Sample Schemas are being created ...
    default: 
    default: 
    default: Connected.
    default: DROP USER hr CASCADE
    default:           *
    default: ERROR at line 1:
    default: ORA-01918: user 'HR' does not exist
    default: 
    default: 
    default: DROP USER oe CASCADE
    default:           *
    default: ERROR at line 1:
    default: ORA-01918: user 'OE' does not exist
    default: 
    default: 
    default: DROP USER pm CASCADE
    default:           *
    default: ERROR at line 1:
    default: ORA-01918: user 'PM' does not exist
    default: 
    default: 
    default: DROP USER ix CASCADE
    default:           *
    default: ERROR at line 1:
    default: ORA-01918: user 'IX' does not exist
    default: 
    default: 
    default: DROP USER sh CASCADE
    default:           *
    default: ERROR at line 1:
    default: ORA-01918: user 'SH' does not exist
    default: 
    default: 
    default: DROP USER bi CASCADE
    default:           *
    default: ERROR at line 1:
    default: ORA-01918: user 'BI' does not exist
    default: 
    default: 
    default: Connected.
    default: 
    default: specify password for HR as parameter 1:
    default: 
    default: specify default tablespeace for HR as parameter 2:
    default: 
    default: specify temporary tablespace for HR as parameter 3:
    default: 
    default: specify password for SYS as parameter 4:
    default: 
    default: specify log path as parameter 5:
    default: 
    default: specify connect string as parameter 6:
    default: 
    default: DROP USER hr CASCADE
    default:           *
    default: ERROR at line 1:
    default: ORA-01918: user 'HR' does not exist
    default: 
    default: 
    default: 
    default: User created.
    default: 
    default: 
    default: User altered.
    default: 
    default: 
    default: User altered.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: Connected.
    default: 
    default: Grant succeeded.
    default: 
    default: Connected.
    default: 
    default: Session altered.
    default: 
    default: 
    default: Session altered.
    default: 
    default: ******  Creating REGIONS table ....
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: ******  Creating COUNTRIES table ....
    default: 
    default: Table created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: ******  Creating LOCATIONS table ....
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Sequence created.
    default: 
    default: ******  Creating DEPARTMENTS table ....
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Sequence created.
    default: 
    default: ******  Creating JOBS table ....
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: ******  Creating EMPLOYEES table ....
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Sequence created.
    default: 
    default: ******  Creating JOB_HISTORY table ....
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: ******  Creating EMP_DETAILS_VIEW view ...
    default: 
    default: View created.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: Session altered.
    default: 
    default: ******  Populating REGIONS table ....
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: ******  Populating COUNTIRES table ....
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: ******  Populating LOCATIONS table ....
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: ******  Populating DEPARTMENTS table ....
    default: 
    default: Table altered.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: ******  Populating JOBS table ....
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: ******  Populating EMPLOYEES table ....
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: ******  Populating JOB_HISTORY table ....
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: Procedure created.
    default: 
    default: 
    default: Trigger created.
    default: 
    default: 
    default: Trigger altered.
    default: 
    default: 
    default: Procedure created.
    default: 
    default: 
    default: Trigger created.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: Connected.
    default: 
    default: specify password for OE as parameter 1:
    default: 
    default: specify default tablespeace for OE as parameter 2:
    default: 
    default: specify temporary tablespace for OE as parameter 3:
    default: 
    default: specify password for HR as parameter 4:
    default: 
    default: specify password for SYS as parameter 5:
    default: 
    default: specify directory path for the data files as parameter 6:
    default: 
    default: writeable directory path for the log files as parameter 7:
    default: 
    default: specify version as parameter 8:
    default: 
    default: specify connect string as parameter 9:
    default: 
    default: DROP USER oe CASCADE
    default:           *
    default: ERROR at line 1:
    default: ORA-01918: user 'OE' does not exist
    default: 
    default: 
    default: 
    default: User created.
    default: 
    default: 
    default: User altered.
    default: 
    default: 
    default: User altered.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: Connected.
    default: 
    default: Grant succeeded.
    default: 
    default: Connected.
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: Connected.
    default: 
    default: Session altered.
    default: 
    default: 
    default: Session altered.
    default: 
    default: 
    default: specify Sample Schema version as parameter 1:
    default: 
    default: specify password for OE as parameter 2:
    default: 
    default: PROMPT password for SYS as parameter 3:
    default: 
    default: specify connect string as parameter 4:
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Trigger created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Sequence created.
    default: 
    default: 
    default: specify password for OE as parameter 1:
    default: 
    default: PROMPT password for SYS as parameter 2:
    default: 
    default: specify connect string as parameter 3:
    default: 
    default: Connected.
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Session altered.
    default: 
    default: 
    default: Package created.
    default: 
    default: 
    default: Warning: Package Body created with compilation errors.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: Package altered.
    default: 
    default: 
    default: View altered.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Trigger created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Call completed.
    default: 
    default: 
    default: Session altered.
    default: 
    default: 
    default: Session altered.
    default: 
    default: 
    default: Package created.
    default: 
    default: 
    default: no rows selected
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Package created.
    default: 
    default: 
    default: no rows selected
    default: 
    default: 
    default: Package body created.
    default: 
    default: 
    default: no rows selected
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Package created.
    default: 
    default: 
    default: no rows selected
    default: 
    default: 
    default: Package body created.
    default: 
    default: 
    default: no rows selected
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Package created.
    default: 
    default: 
    default: no rows selected
    default: 
    default: 
    default: Package body created.
    default: 
    default: 
    default: no rows selected
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: specify password for OE as parameter 1:
    default: 
    default: PROMPT password for SYS as parameter 2:
    default: 
    default: specify connect string as parameter 3:
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: Connected.
    default: DROP DIRECTORY SS_OE_XMLDIR
    default: *
    default: ERROR at line 1:
    default: ORA-04043: Object SS_OE_XMLDIR does not exist.
    default: 
    default: 
    default: 
    default: Directory created.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: Connected.
    default: 
    default: Revoke succeeded.
    default: 
    default: Connected.
    default: Connected.
    default: 
    default: Session altered.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: 
    default: Call completed.
    default: 
    default: 
    default: Call completed.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: Connected.
    default: 
    default: Revoke succeeded.
    default: 
    default: Connected.
    default: Connected.
    default: 
    default: Revoke succeeded.
    default: 
    default: 
    default: Revoke succeeded.
    default: 
    default: 
    default: Revoke succeeded.
    default: 
    default: 
    default: Package dropped.
    default: 
    default: 
    default: Package dropped.
    default: 
    default: 
    default: Package dropped.
    default: 
    default: 
    default: Package dropped.
    default: 
    default: 
    default: Package dropped.
    default: 
    default: 
    default: Trigger dropped.
    default: 
    default: 
    default: View dropped.
    default: 
    default: Connected.
    default: 
    default: Commit complete.
    default: 
    default: 
    default: specify Sample Schema version as parameter 1:
    default: 
    default: specify location for data and control files as parameter 2:
    default: 
    default: specify location for log files as parameter 3:
    default: 
    default: specify password for oe as parameter 4:
    default: 
    default: Setting FEEDBACK OFF for inserts
    default: 
    default: Setting FEEDBACK ON
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Session altered.
    default: 
    default: 
    default: Session altered.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: Function created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Session altered.
    default: 
    default: ...creating subschema OC in OE
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type body created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type body created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type body created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: Trigger created.
    default: 
    default: 
    default: Trigger created.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: 1 row created.
    default: 
    default: 
    default: Type altered.
    default: 
    default: 
    default: 3 rows updated.
    default: 
    default: 
    default: 8 rows updated.
    default: 
    default: 
    default: 6 rows updated.
    default: 
    default: 
    default: 4 rows updated.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: Type body altered.
    default: 
    default: 
    default: Type body altered.
    default: 
    default: 
    default: Type body altered.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: Connected.
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: Connected.
    default: 
    default: specify password for PM as parameter 1:
    default: 
    default: specify default tablespeace for PM as parameter 2:
    default: 
    default: specify temporary tablespace for PM as parameter 3:
    default: 
    default: specify password for OE as parameter 4:
    default: 
    default: specify password for SYS as parameter 5:
    default: 
    default: specify directory path for the PM data files as parameter 6:
    default: 
    default: specify directory path for the PM load log files as parameter 7:
    default: 
    default: specify work directory path as parameter 8:
    default: 
    default: specify connect string as parameter 9:
    default: 
    default: DROP USER pm CASCADE
    default:           *
    default: ERROR at line 1:
    default: ORA-01918: user 'PM' does not exist
    default: 
    default: 
    default: 
    default: User created.
    default: 
    default: 
    default: User altered.
    default: 
    default: 
    default: User altered.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: Connected.
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: Connected.
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Directory created.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: Connected.
    default: 
    default: Session altered.
    default: 
    default: 
    default: Session altered.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Type created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: SQL*Loader: Release 23.0.0.0.0 - Developer-Release on Tue Apr 11 03:16:45 2023
    default: Version 23.2.0.0.0
    default: 
    default: Copyright (c) 1982, 2023, Oracle and/or its affiliates.  All rights reserved.
    default: 
    default: Path used:      Conventional
    default: Commit point reached - logical record count 15
    default: Commit point reached - logical record count 16
    default: 
    default: Table PRINT_MEDIA:
    default:   4 Rows successfully loaded.
    default: 
    default: Table TEXTDOCS_NESTEDTAB:
    default:   12 Rows successfully loaded.
    default: 
    default: Check the log file:
    default:   /tmp/tmp.vA7KvKRnru/log/pm_p_lob.log
    default: for more information about the load.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: Connected.
    default: 
    default: specify password for IX as parameter 1:
    default: 
    default: specify default tablespeace for IX as parameter 2:
    default: 
    default: specify temporary tablespace for IX as parameter 3:
    default: 
    default: specify password for SYS as parameter 4:
    default: 
    default: specify path for log files as parameter 5:
    default: 
    default: specify version as parameter 6:
    default: 
    default: specify connect string as parameter 7:
    default: 
    default: dropping user ...
    default: DROP USER ix CASCADE
    default:           *
    default: ERROR at line 1:
    default: ORA-01918: user 'IX' does not exist
    default: 
    default: 
    default: creating user ...
    default: 
    default: 
    default: User created.
    default: 
    default: 
    default: User altered.
    default: 
    default: 
    default: User altered.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: Connected.
    default: Granting Streams privileges, vrs=v3 ...
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: setting job_queue_processes and aq_tm_processes ...
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: Connected.
    default: 
    default: Type created.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: Connected.
    default: 
    default: Session altered.
    default: 
    default: 
    default: Session altered.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: 
    default: QUEUE           MSG_STATE       CONSUMER_NAME   USER_DATA(ORDER_ID, PRODUCT_ID, CUSTOMER_ID, CUST_FIRST_NAME
    default: --------------- --------------- --------------- ------------------------------------------------------------
    default: ORDERS_QUEUE    READY           BILLING         ORDER_EVENT_TYP(2458, 3117, 101, 'Constantin', 'Welles', 0,
    default:                                                 '12-DEC-02')
    default: 
    default: ORDERS_QUEUE    READY           SHIPPING        ORDER_EVENT_TYP(2458, 3117, 101, 'Constantin', 'Welles', 0,
    default:                                                 '12-DEC-02')
    default: 
    default: 
    default: 2 rows selected.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: 
    default: QUEUE           MSG_STATE       CONSUMER_NAME   USER_DATA(ORDER_ID, PRODUCT_ID, CUSTOMER_ID, CUST_FIRST_NAME
    default: --------------- --------------- --------------- ------------------------------------------------------------
    default: ORDERS_QUEUE    READY           BILLING         ORDER_EVENT_TYP(2458, 3117, 101, 'Constantin', 'Welles', 0,
    default:                                                 '12-DEC-02')
    default: 
    default: ORDERS_QUEUE    PROCESSED       SHIPPING        ORDER_EVENT_TYP(2458, 3117, 101, 'Constantin', 'Welles', 0,
    default:                                                 '12-DEC-02')
    default: 
    default: 
    default: 2 rows selected.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: 
    default: QUEUE           MSG_STATE       CONSUMER_NAME   USER_DATA(ORDER_ID, PRODUCT_ID, CUSTOMER_ID, CUST_FIRST_NAME
    default: --------------- --------------- --------------- ------------------------------------------------------------
    default: ORDERS_QUEUE    PROCESSED       BILLING         ORDER_EVENT_TYP(2458, 3117, 101, 'Constantin', 'Welles', 0,
    default:                                                 '12-DEC-02')
    default: 
    default: ORDERS_QUEUE    PROCESSED       SHIPPING        ORDER_EVENT_TYP(2458, 3117, 101, 'Constantin', 'Welles', 0,
    default:                                                 '12-DEC-02')
    default: 
    default: 
    default: 2 rows selected.
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: 
    default: OBJECT_TYPE          OBJECT_NAME                    STATUS
    default: -------------------- ------------------------------ -------
    default: EVALUATION CONTEXT   AQ$_ORDERS_QUEUETABLE_V        VALID
    default: EVALUATION CONTEXT   AQ$_STREAMS_QUEUE_TABLE_V      VALID
    default: INDEX                AQ$_STREAMS_QUEUE_TABLE_Y      VALID
    default: INDEX                SYS_C008303                    VALID
    default: INDEX                SYS_C008306                    VALID
    default: INDEX                SYS_C008315                    VALID
    default: INDEX                SYS_C008318                    VALID
    default: INDEX                SYS_IL0000078086C00036$$       VALID
    default: INDEX                SYS_IL0000078113C00028$$       VALID
    default: INDEX                SYS_IL0000078113C00029$$       VALID
    default: INDEX                SYS_IOT_TOP_78095              VALID
    default: INDEX                SYS_IOT_TOP_78097              VALID
    default: INDEX                SYS_IOT_TOP_78100              VALID
    default: INDEX                SYS_IOT_TOP_78103              VALID
    default: INDEX                SYS_IOT_TOP_78124              VALID
    default: INDEX                SYS_IOT_TOP_78126              VALID
    default: INDEX                SYS_IOT_TOP_78129              VALID
    default: INDEX                SYS_IOT_TOP_78132              VALID
    default: INDEX                SYS_IOT_TOP_78134              VALID
    default: LOB                  SYS_LOB0000078086C00036$$      VALID
    default: LOB                  SYS_LOB0000078113C00028$$      VALID
    default: LOB                  SYS_LOB0000078113C00029$$      VALID
    default: QUEUE                AQ$_ORDERS_QUEUETABLE_E        VALID
    default: QUEUE                AQ$_STREAMS_QUEUE_TABLE_E      VALID
    default: QUEUE                ORDERS_QUEUE                   VALID
    default: QUEUE                STREAMS_QUEUE                  VALID
    default: RULE SET             ORDERS_QUEUE_N                 VALID
    default: RULE SET             ORDERS_QUEUE_R                 VALID
    default: RULE SET             STREAMS_QUEUE_N                VALID
    default: RULE SET             STREAMS_QUEUE_R                VALID
    default: SEQUENCE             AQ$_ORDERS_QUEUETABLE_N        VALID
    default: SEQUENCE             AQ$_STREAMS_QUEUE_TABLE_N      VALID
    default: TABLE                AQ$_ORDERS_QUEUETABLE_G        VALID
    default: TABLE                AQ$_ORDERS_QUEUETABLE_H        VALID
    default: TABLE                AQ$_ORDERS_QUEUETABLE_I        VALID
    default: TABLE                AQ$_ORDERS_QUEUETABLE_L        VALID
    default: TABLE                AQ$_ORDERS_QUEUETABLE_S        VALID
    default: TABLE                AQ$_ORDERS_QUEUETABLE_T        VALID
    default: TABLE                AQ$_STREAMS_QUEUE_TABLE_C      VALID
    default: TABLE                AQ$_STREAMS_QUEUE_TABLE_G      VALID
    default: TABLE                AQ$_STREAMS_QUEUE_TABLE_H      VALID
    default: TABLE                AQ$_STREAMS_QUEUE_TABLE_I      VALID
    default: TABLE                AQ$_STREAMS_QUEUE_TABLE_L      VALID
    default: TABLE                AQ$_STREAMS_QUEUE_TABLE_S      VALID
    default: TABLE                AQ$_STREAMS_QUEUE_TABLE_T      VALID
    default: TABLE                ORDERS_QUEUETABLE              VALID
    default: TABLE                STREAMS_QUEUE_TABLE            VALID
    default: TABLE                SYS_IOT_OVER_78100             VALID
    default: TABLE                SYS_IOT_OVER_78129             VALID
    default: TYPE                 ORDER_EVENT_TYP                VALID
    default: VIEW                 AQ$ORDERS_QUEUETABLE           VALID
    default: VIEW                 AQ$ORDERS_QUEUETABLE_R         VALID
    default: VIEW                 AQ$ORDERS_QUEUETABLE_S         VALID
    default: VIEW                 AQ$STREAMS_QUEUE_TABLE         VALID
    default: VIEW                 AQ$STREAMS_QUEUE_TABLE_R       VALID
    default: VIEW                 AQ$STREAMS_QUEUE_TABLE_S       VALID
    default: VIEW                 AQ$_ORDERS_QUEUETABLE_F        VALID
    default: VIEW                 AQ$_STREAMS_QUEUE_TABLE_F      VALID
    default: 
    default: 58 rows selected.
    default: 
    default: 
    default: OBJECT_TYPE          STATUS    COUNT(*)
    default: -------------------- ------- ----------
    default: EVALUATION CONTEXT   VALID            2
    default: INDEX                VALID           17
    default: LOB                  VALID            3
    default: QUEUE                VALID            4
    default: RULE SET             VALID            4
    default: SEQUENCE             VALID            2
    default: TABLE                VALID           17
    default: TYPE                 VALID            1
    default: VIEW                 VALID            8
    default: 
    default: 9 rows selected.
    default: 
    default: Connected.
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: Connected.
    default: 
    default: specify password for SH as parameter 1:
    default: 
    default: specify default tablespace for SH as parameter 2:
    default: 
    default: specify temporary tablespace for SH as parameter 3:
    default: 
    default: specify password for SYS as parameter 4:
    default: 
    default: specify directory path for the data files as parameter 5:
    default: 
    default: writeable directory path for the log files as parameter 6:
    default: 
    default: specify version as parameter 7:
    default: 
    default: specify connect string as parameter 8:
    default: 
    default: 
    default: Session altered.
    default: 
    default: DROP USER sh CASCADE
    default:           *
    default: ERROR at line 1:
    default: ORA-01918: user 'SH' does not exist
    default: 
    default: 
    default: 
    default: User created.
    default: 
    default: 
    default: User altered.
    default: 
    default: 
    default: User altered.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: Connected.
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Directory created.
    default: 
    default: 
    default: Directory created.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: Connected.
    default: 
    default: Session altered.
    default: 
    default: 
    default: Session altered.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Creating constraints ...
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: specify password for SH as parameter 1:
    default: 
    default: specify path for data files as parameter 2:
    default: 
    default: specify path for log files as parameter 3:
    default: 
    default: specify version as parameter 4:
    default: 
    default: specify connect string as parameter 5:
    default: 
    default: Looking for indexes that could slow down load ...
    default: 
    default: no rows selected
    default: 
    default: 
    default: loading TIMES using:
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/time_v3.ctl
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/time_v3.dat
    default: /tmp/tmp.vA7KvKRnru/log/time_v3.log
    default: 
    default: SQL*Loader: Release 23.0.0.0.0 - Developer-Release on Tue Apr 11 03:17:04 2023
    default: Version 23.2.0.0.0
    default: 
    default: Copyright (c) 1982, 2023, Oracle and/or its affiliates.  All rights reserved.
    default: 
    default: Path used:      Direct
    default: Save data point reached - logical record count 1000.
    default: 
    default: Load completed - logical record count 1826.
    default: 
    default: Table TIMES:
    default:   1826 Rows successfully loaded.
    default: 
    default: Check the log file:
    default:   /tmp/tmp.vA7KvKRnru/log/time_v3.log
    default: for more information about the load.
    default: 
    default: 
    default: loading COUNTRIES using:
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/coun_v3.ctl
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/coun_v3.dat
    default: /tmp/tmp.vA7KvKRnru/log/coun_v3.log
    default: 
    default: SQL*Loader: Release 23.0.0.0.0 - Developer-Release on Tue Apr 11 03:17:06 2023
    default: Version 23.2.0.0.0
    default: 
    default: Copyright (c) 1982, 2023, Oracle and/or its affiliates.  All rights reserved.
    default: 
    default: Path used:      Direct
    default: 
    default: Load completed - logical record count 23.
    default: 
    default: Table COUNTRIES:
    default:   23 Rows successfully loaded.
    default: 
    default: Check the log file:
    default:   /tmp/tmp.vA7KvKRnru/log/coun_v3.log
    default: for more information about the load.
    default: 
    default: 
    default: loading CUSTOMERS using:
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/cust_v3.ctl
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/cust1v3.dat
    default: /tmp/tmp.vA7KvKRnru/log/cust1v3.log
    default: 
    default: SQL*Loader: Release 23.0.0.0.0 - Developer-Release on Tue Apr 11 03:17:09 2023
    default: Version 23.2.0.0.0
    default: 
    default: Copyright (c) 1982, 2023, Oracle and/or its affiliates.  All rights reserved.
    default: 
    default: Path used:      Direct
    default: Save data point reached - logical record count 10000.
    default: Save data point reached - logical record count 20000.
    default: Save data point reached - logical record count 30000.
    default: Save data point reached - logical record count 40000.
    default: Save data point reached - logical record count 50000.
    default: 
    default: Load completed - logical record count 55500.
    default: 
    default: Table CUSTOMERS:
    default:   55500 Rows successfully loaded.
    default: 
    default: Check the log file:
    default:   /tmp/tmp.vA7KvKRnru/log/cust1v3.log
    default: for more information about the load.
    default: 
    default: 
    default: loading PRODUCTS  using:
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/prod_v3.ctl
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/prod1v3.dat
    default: /tmp/tmp.vA7KvKRnru/log/prod1v3.log
    default: 
    default: SQL*Loader: Release 23.0.0.0.0 - Developer-Release on Tue Apr 11 03:17:11 2023
    default: Version 23.2.0.0.0
    default: 
    default: Copyright (c) 1982, 2023, Oracle and/or its affiliates.  All rights reserved.
    default: 
    default: Path used:      Direct
    default: 
    default: Load completed - logical record count 72.
    default: 
    default: Table PRODUCTS:
    default:   72 Rows successfully loaded.
    default: 
    default: Check the log file:
    default:   /tmp/tmp.vA7KvKRnru/log/prod1v3.log
    default: for more information about the load.
    default: 
    default: 
    default: loading PROMOTIONS  using:
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/prom_v3.ctl
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/prom1v3.dat
    default: /tmp/tmp.vA7KvKRnru/log/prom1v3.log
    default: 
    default: SQL*Loader: Release 23.0.0.0.0 - Developer-Release on Tue Apr 11 03:17:14 2023
    default: Version 23.2.0.0.0
    default: 
    default: Copyright (c) 1982, 2023, Oracle and/or its affiliates.  All rights reserved.
    default: 
    default: Path used:      Direct
    default: Save data point reached - logical record count 10.
    default: Save data point reached - logical record count 20.
    default: Save data point reached - logical record count 30.
    default: Save data point reached - logical record count 40.
    default: Save data point reached - logical record count 50.
    default: Save data point reached - logical record count 60.
    default: Save data point reached - logical record count 70.
    default: Save data point reached - logical record count 80.
    default: Save data point reached - logical record count 90.
    default: Save data point reached - logical record count 100.
    default: Save data point reached - logical record count 110.
    default: Save data point reached - logical record count 120.
    default: Save data point reached - logical record count 130.
    default: Save data point reached - logical record count 140.
    default: Save data point reached - logical record count 150.
    default: Save data point reached - logical record count 160.
    default: Save data point reached - logical record count 170.
    default: Save data point reached - logical record count 180.
    default: Save data point reached - logical record count 190.
    default: Save data point reached - logical record count 200.
    default: Save data point reached - logical record count 210.
    default: Save data point reached - logical record count 220.
    default: Save data point reached - logical record count 230.
    default: Save data point reached - logical record count 240.
    default: Save data point reached - logical record count 250.
    default: Save data point reached - logical record count 260.
    default: Save data point reached - logical record count 270.
    default: Save data point reached - logical record count 280.
    default: Save data point reached - logical record count 290.
    default: Save data point reached - logical record count 300.
    default: Save data point reached - logical record count 310.
    default: Save data point reached - logical record count 320.
    default: Save data point reached - logical record count 330.
    default: Save data point reached - logical record count 340.
    default: Save data point reached - logical record count 350.
    default: Save data point reached - logical record count 360.
    default: Save data point reached - logical record count 370.
    default: Save data point reached - logical record count 380.
    default: Save data point reached - logical record count 390.
    default: Save data point reached - logical record count 400.
    default: Save data point reached - logical record count 410.
    default: Save data point reached - logical record count 420.
    default: Save data point reached - logical record count 430.
    default: Save data point reached - logical record count 440.
    default: Save data point reached - logical record count 450.
    default: Save data point reached - logical record count 460.
    default: Save data point reached - logical record count 470.
    default: Save data point reached - logical record count 480.
    default: Save data point reached - logical record count 490.
    default: Save data point reached - logical record count 500.
    default: 
    default: Load completed - logical record count 503.
    default: 
    default: Table PROMOTIONS:
    default:   503 Rows successfully loaded.
    default: 
    default: Check the log file:
    default:   /tmp/tmp.vA7KvKRnru/log/prom1v3.log
    default: for more information about the load.
    default: 
    default: 
    default: loading CHANNELS using:
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/chan_v3.ctl
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/chan_v3.dat
    default: /tmp/tmp.vA7KvKRnru/log/chan_v3.log
    default: 
    default: SQL*Loader: Release 23.0.0.0.0 - Developer-Release on Tue Apr 11 03:17:16 2023
    default: Version 23.2.0.0.0
    default: 
    default: Copyright (c) 1982, 2023, Oracle and/or its affiliates.  All rights reserved.
    default: 
    default: Path used:      Direct
    default: 
    default: Load completed - logical record count 5.
    default: 
    default: Table CHANNELS:
    default:   5 Rows successfully loaded.
    default: 
    default: Check the log file:
    default:   /tmp/tmp.vA7KvKRnru/log/chan_v3.log
    default: for more information about the load.
    default: 
    default: 
    default: loading SALES  using:
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/sale_v3.ctl
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/sale1v3.dat
    default: /tmp/tmp.vA7KvKRnru/log/sale1v3.log
    default: 
    default: SQL*Loader: Release 23.0.0.0.0 - Developer-Release on Tue Apr 11 03:17:18 2023
    default: Version 23.2.0.0.0
    default: 
    default: Copyright (c) 1982, 2023, Oracle and/or its affiliates.  All rights reserved.
    default: 
    default: Path used:      Direct
    default: Save data point reached - logical record count 100000.
    default: Save data point reached - logical record count 200000.
    default: Save data point reached - logical record count 300000.
    default: Save data point reached - logical record count 400000.
    default: Save data point reached - logical record count 500000.
    default: Save data point reached - logical record count 600000.
    default: Save data point reached - logical record count 700000.
    default: Save data point reached - logical record count 800000.
    default: Save data point reached - logical record count 900000.
    default: 
    default: Load completed - logical record count 916039.
    default: 
    default: Table SALES:
    default:   916039 Rows successfully loaded.
    default: 
    default: Check the log file:
    default:   /tmp/tmp.vA7KvKRnru/log/sale1v3.log
    default: for more information about the load.
    default: 
    default: 
    default: loading COSTS using external table
    default: 
    default: 
    default: Table created.
    default: 
    default: INSERT /*+ append */ INTO costs
    default: *
    default: ERROR at line 1:
    default: ORA-29913: error while processing ODCIEXTTABLEOPEN routine
    default: ORA-29400: data cartridge error
    default: KUP-04005: error while accessing file /tmp/tmp.vA7KvKRnru/log/ext_1v3.log
    default: 
    default: 
    default: 
    default: loading additonal SALES using:
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/dmsal_v3.ctl
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/dmsal_v3.dat
    default: /tmp/tmp.vA7KvKRnru/log/dmsal_v3.log
    default: 
    default: SQL*Loader: Release 23.0.0.0.0 - Developer-Release on Tue Apr 11 03:17:26 2023
    default: Version 23.2.0.0.0
    default: 
    default: Copyright (c) 1982, 2023, Oracle and/or its affiliates.  All rights reserved.
    default: 
    default: Path used:      Direct
    default: Save data point reached - logical record count 100.
    default: Save data point reached - logical record count 200.
    default: Save data point reached - logical record count 300.
    default: Save data point reached - logical record count 400.
    default: Save data point reached - logical record count 500.
    default: Save data point reached - logical record count 600.
    default: Save data point reached - logical record count 700.
    default: Save data point reached - logical record count 800.
    default: Save data point reached - logical record count 900.
    default: Save data point reached - logical record count 1000.
    default: Save data point reached - logical record count 1100.
    default: Save data point reached - logical record count 1200.
    default: Save data point reached - logical record count 1300.
    default: Save data point reached - logical record count 1400.
    default: Save data point reached - logical record count 1500.
    default: Save data point reached - logical record count 1600.
    default: Save data point reached - logical record count 1700.
    default: Save data point reached - logical record count 1800.
    default: Save data point reached - logical record count 1900.
    default: Save data point reached - logical record count 2000.
    default: Save data point reached - logical record count 2100.
    default: Save data point reached - logical record count 2200.
    default: Save data point reached - logical record count 2300.
    default: Save data point reached - logical record count 2400.
    default: Save data point reached - logical record count 2500.
    default: Save data point reached - logical record count 2600.
    default: Save data point reached - logical record count 2700.
    default: Save data point reached - logical record count 2800.
    default: 
    default: Load completed - logical record count 2804.
    default: 
    default: Table SALES:
    default:   2804 Rows successfully loaded.
    default: 
    default: Check the log file:
    default:   /tmp/tmp.vA7KvKRnru/log/dmsal_v3.log
    default: for more information about the load.
    default: 
    default: 
    default: loading SUPPLEMENTARY DEMOGRAPHICS using:
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/dem_v3.ctl
    default: /tmp/tmp.vA7KvKRnru/db-sample-schemas-21.1/sales_history/dem1v3.dat
    default: /tmp/tmp.vA7KvKRnru/log/dem1v3.log
    default: 
    default: SQL*Loader: Release 23.0.0.0.0 - Developer-Release on Tue Apr 11 03:17:30 2023
    default: Version 23.2.0.0.0
    default: 
    default: Copyright (c) 1982, 2023, Oracle and/or its affiliates.  All rights reserved.
    default: 
    default: Path used:      Direct
    default: Save data point reached - logical record count 10.
    default: Save data point reached - logical record count 20.
    default: Save data point reached - logical record count 30.
    default: Save data point reached - logical record count 40.
    default: Save data point reached - logical record count 50.
    default: Save data point reached - logical record count 60.
    default: Save data point reached - logical record count 70.
    default: Save data point reached - logical record count 80.
    default: Save data point reached - logical record count 90.
    default: Save data point reached - logical record count 100.
    default: Save data point reached - logical record count 110.
    default: Save data point reached - logical record count 120.
    default: Save data point reached - logical record count 130.
    default: Save data point reached - logical record count 140.
    default: Save data point reached - logical record count 150.
    default: Save data point reached - logical record count 160.
    default: Save data point reached - logical record count 170.
    default: Save data point reached - logical record count 180.
    default: Save data point reached - logical record count 190.
    default: Save data point reached - logical record count 200.
    default: Save data point reached - logical record count 210.
    default: Save data point reached - logical record count 220.
    default: Save data point reached - logical record count 230.
    default: Save data point reached - logical record count 240.
    default: Save data point reached - logical record count 250.
    default: Save data point reached - logical record count 260.
    default: Save data point reached - logical record count 270.
    default: Save data point reached - logical record count 280.
    default: Save data point reached - logical record count 290.
    default: Save data point reached - logical record count 300.
    default: Save data point reached - logical record count 310.
    default: Save data point reached - logical record count 320.
    default: Save data point reached - logical record count 330.
    default: Save data point reached - logical record count 340.
    default: Save data point reached - logical record count 350.
    default: Save data point reached - logical record count 360.
    default: Save data point reached - logical record count 370.
    default: Save data point reached - logical record count 380.
    default: Save data point reached - logical record count 390.
    default: Save data point reached - logical record count 400.
    default: Save data point reached - logical record count 410.
    default: Save data point reached - logical record count 420.
    default: Save data point reached - logical record count 430.
    default: Save data point reached - logical record count 440.
    default: Save data point reached - logical record count 450.
    default: Save data point reached - logical record count 460.
    default: Save data point reached - logical record count 470.
    default: Save data point reached - logical record count 480.
    default: Save data point reached - logical record count 490.
    default: Save data point reached - logical record count 500.
    default: Save data point reached - logical record count 510.
    default: Save data point reached - logical record count 520.
    default: Save data point reached - logical record count 530.
    default: Save data point reached - logical record count 540.
    default: Save data point reached - logical record count 550.
    default: Save data point reached - logical record count 560.
    default: Save data point reached - logical record count 570.
    default: Save data point reached - logical record count 580.
    default: Save data point reached - logical record count 590.
    default: Save data point reached - logical record count 600.
    default: Save data point reached - logical record count 610.
    default: Save data point reached - logical record count 620.
    default: Save data point reached - logical record count 630.
    default: Save data point reached - logical record count 640.
    default: Save data point reached - logical record count 650.
    default: Save data point reached - logical record count 660.
    default: Save data point reached - logical record count 670.
    default: Save data point reached - logical record count 680.
    default: Save data point reached - logical record count 690.
    default: Save data point reached - logical record count 700.
    default: Save data point reached - logical record count 710.
    default: Save data point reached - logical record count 720.
    default: Save data point reached - logical record count 730.
    default: Save data point reached - logical record count 740.
    default: Save data point reached - logical record count 750.
    default: Save data point reached - logical record count 760.
    default: Save data point reached - logical record count 770.
    default: Save data point reached - logical record count 780.
    default: Save data point reached - logical record count 790.
    default: Save data point reached - logical record count 800.
    default: Save data point reached - logical record count 810.
    default: Save data point reached - logical record count 820.
    default: Save data point reached - logical record count 830.
    default: Save data point reached - logical record count 840.
    default: Save data point reached - logical record count 850.
    default: Save data point reached - logical record count 860.
    default: Save data point reached - logical record count 870.
    default: Save data point reached - logical record count 880.
    default: Save data point reached - logical record count 890.
    default: Save data point reached - logical record count 900.
    default: Save data point reached - logical record count 910.
    default: Save data point reached - logical record count 920.
    default: Save data point reached - logical record count 930.
    default: Save data point reached - logical record count 940.
    default: Save data point reached - logical record count 950.
    default: Save data point reached - logical record count 960.
    default: Save data point reached - logical record count 970.
    default: Save data point reached - logical record count 980.
    default: Save data point reached - logical record count 990.
    default: Save data point reached - logical record count 1000.
    default: Save data point reached - logical record count 1010.
    default: Save data point reached - logical record count 1020.
    default: Save data point reached - logical record count 1030.
    default: Save data point reached - logical record count 1040.
    default: Save data point reached - logical record count 1050.
    default: Save data point reached - logical record count 1060.
    default: Save data point reached - logical record count 1070.
    default: Save data point reached - logical record count 1080.
    default: Save data point reached - logical record count 1090.
    default: Save data point reached - logical record count 1100.
    default: Save data point reached - logical record count 1110.
    default: Save data point reached - logical record count 1120.
    default: Save data point reached - logical record count 1130.
    default: Save data point reached - logical record count 1140.
    default: Save data point reached - logical record count 1150.
    default: Save data point reached - logical record count 1160.
    default: Save data point reached - logical record count 1170.
    default: Save data point reached - logical record count 1180.
    default: Save data point reached - logical record count 1190.
    default: Save data point reached - logical record count 1200.
    default: Save data point reached - logical record count 1210.
    default: Save data point reached - logical record count 1220.
    default: Save data point reached - logical record count 1230.
    default: Save data point reached - logical record count 1240.
    default: Save data point reached - logical record count 1250.
    default: Save data point reached - logical record count 1260.
    default: Save data point reached - logical record count 1270.
    default: Save data point reached - logical record count 1280.
    default: Save data point reached - logical record count 1290.
    default: Save data point reached - logical record count 1300.
    default: Save data point reached - logical record count 1310.
    default: Save data point reached - logical record count 1320.
    default: Save data point reached - logical record count 1330.
    default: Save data point reached - logical record count 1340.
    default: Save data point reached - logical record count 1350.
    default: Save data point reached - logical record count 1360.
    default: Save data point reached - logical record count 1370.
    default: Save data point reached - logical record count 1380.
    default: Save data point reached - logical record count 1390.
    default: Save data point reached - logical record count 1400.
    default: Save data point reached - logical record count 1410.
    default: Save data point reached - logical record count 1420.
    default: Save data point reached - logical record count 1430.
    default: Save data point reached - logical record count 1440.
    default: Save data point reached - logical record count 1450.
    default: Save data point reached - logical record count 1460.
    default: Save data point reached - logical record count 1470.
    default: Save data point reached - logical record count 1480.
    default: Save data point reached - logical record count 1490.
    default: Save data point reached - logical record count 1500.
    default: Save data point reached - logical record count 1510.
    default: Save data point reached - logical record count 1520.
    default: Save data point reached - logical record count 1530.
    default: Save data point reached - logical record count 1540.
    default: Save data point reached - logical record count 1550.
    default: Save data point reached - logical record count 1560.
    default: Save data point reached - logical record count 1570.
    default: Save data point reached - logical record count 1580.
    default: Save data point reached - logical record count 1590.
    default: Save data point reached - logical record count 1600.
    default: Save data point reached - logical record count 1610.
    default: Save data point reached - logical record count 1620.
    default: Save data point reached - logical record count 1630.
    default: Save data point reached - logical record count 1640.
    default: Save data point reached - logical record count 1650.
    default: Save data point reached - logical record count 1660.
    default: Save data point reached - logical record count 1670.
    default: Save data point reached - logical record count 1680.
    default: Save data point reached - logical record count 1690.
    default: Save data point reached - logical record count 1700.
    default: Save data point reached - logical record count 1710.
    default: Save data point reached - logical record count 1720.
    default: Save data point reached - logical record count 1730.
    default: Save data point reached - logical record count 1740.
    default: Save data point reached - logical record count 1750.
    default: Save data point reached - logical record count 1760.
    default: Save data point reached - logical record count 1770.
    default: Save data point reached - logical record count 1780.
    default: Save data point reached - logical record count 1790.
    default: Save data point reached - logical record count 1800.
    default: Save data point reached - logical record count 1810.
    default: Save data point reached - logical record count 1820.
    default: Save data point reached - logical record count 1830.
    default: Save data point reached - logical record count 1840.
    default: Save data point reached - logical record count 1850.
    default: Save data point reached - logical record count 1860.
    default: Save data point reached - logical record count 1870.
    default: Save data point reached - logical record count 1880.
    default: Save data point reached - logical record count 1890.
    default: Save data point reached - logical record count 1900.
    default: Save data point reached - logical record count 1910.
    default: Save data point reached - logical record count 1920.
    default: Save data point reached - logical record count 1930.
    default: Save data point reached - logical record count 1940.
    default: Save data point reached - logical record count 1950.
    default: Save data point reached - logical record count 1960.
    default: Save data point reached - logical record count 1970.
    default: Save data point reached - logical record count 1980.
    default: Save data point reached - logical record count 1990.
    default: Save data point reached - logical record count 2000.
    default: Save data point reached - logical record count 2010.
    default: Save data point reached - logical record count 2020.
    default: Save data point reached - logical record count 2030.
    default: Save data point reached - logical record count 2040.
    default: Save data point reached - logical record count 2050.
    default: Save data point reached - logical record count 2060.
    default: Save data point reached - logical record count 2070.
    default: Save data point reached - logical record count 2080.
    default: Save data point reached - logical record count 2090.
    default: Save data point reached - logical record count 2100.
    default: Save data point reached - logical record count 2110.
    default: Save data point reached - logical record count 2120.
    default: Save data point reached - logical record count 2130.
    default: Save data point reached - logical record count 2140.
    default: Save data point reached - logical record count 2150.
    default: Save data point reached - logical record count 2160.
    default: Save data point reached - logical record count 2170.
    default: Save data point reached - logical record count 2180.
    default: Save data point reached - logical record count 2190.
    default: Save data point reached - logical record count 2200.
    default: Save data point reached - logical record count 2210.
    default: Save data point reached - logical record count 2220.
    default: Save data point reached - logical record count 2230.
    default: Save data point reached - logical record count 2240.
    default: Save data point reached - logical record count 2250.
    default: Save data point reached - logical record count 2260.
    default: Save data point reached - logical record count 2270.
    default: Save data point reached - logical record count 2280.
    default: Save data point reached - logical record count 2290.
    default: Save data point reached - logical record count 2300.
    default: Save data point reached - logical record count 2310.
    default: Save data point reached - logical record count 2320.
    default: Save data point reached - logical record count 2330.
    default: Save data point reached - logical record count 2340.
    default: Save data point reached - logical record count 2350.
    default: Save data point reached - logical record count 2360.
    default: Save data point reached - logical record count 2370.
    default: Save data point reached - logical record count 2380.
    default: Save data point reached - logical record count 2390.
    default: Save data point reached - logical record count 2400.
    default: Save data point reached - logical record count 2410.
    default: Save data point reached - logical record count 2420.
    default: Save data point reached - logical record count 2430.
    default: Save data point reached - logical record count 2440.
    default: Save data point reached - logical record count 2450.
    default: Save data point reached - logical record count 2460.
    default: Save data point reached - logical record count 2470.
    default: Save data point reached - logical record count 2480.
    default: Save data point reached - logical record count 2490.
    default: Save data point reached - logical record count 2500.
    default: Save data point reached - logical record count 2510.
    default: Save data point reached - logical record count 2520.
    default: Save data point reached - logical record count 2530.
    default: Save data point reached - logical record count 2540.
    default: Save data point reached - logical record count 2550.
    default: Save data point reached - logical record count 2560.
    default: Save data point reached - logical record count 2570.
    default: Save data point reached - logical record count 2580.
    default: Save data point reached - logical record count 2590.
    default: Save data point reached - logical record count 2600.
    default: Save data point reached - logical record count 2610.
    default: Save data point reached - logical record count 2620.
    default: Save data point reached - logical record count 2630.
    default: Save data point reached - logical record count 2640.
    default: Save data point reached - logical record count 2650.
    default: Save data point reached - logical record count 2660.
    default: Save data point reached - logical record count 2670.
    default: Save data point reached - logical record count 2680.
    default: Save data point reached - logical record count 2690.
    default: Save data point reached - logical record count 2700.
    default: Save data point reached - logical record count 2710.
    default: Save data point reached - logical record count 2720.
    default: Save data point reached - logical record count 2730.
    default: Save data point reached - logical record count 2740.
    default: Save data point reached - logical record count 2750.
    default: Save data point reached - logical record count 2760.
    default: Save data point reached - logical record count 2770.
    default: Save data point reached - logical record count 2780.
    default: Save data point reached - logical record count 2790.
    default: Save data point reached - logical record count 2800.
    default: Save data point reached - logical record count 2810.
    default: Save data point reached - logical record count 2820.
    default: Save data point reached - logical record count 2830.
    default: Save data point reached - logical record count 2840.
    default: Save data point reached - logical record count 2850.
    default: Save data point reached - logical record count 2860.
    default: Save data point reached - logical record count 2870.
    default: Save data point reached - logical record count 2880.
    default: Save data point reached - logical record count 2890.
    default: Save data point reached - logical record count 2900.
    default: Save data point reached - logical record count 2910.
    default: Save data point reached - logical record count 2920.
    default: Save data point reached - logical record count 2930.
    default: Save data point reached - logical record count 2940.
    default: Save data point reached - logical record count 2950.
    default: Save data point reached - logical record count 2960.
    default: Save data point reached - logical record count 2970.
    default: Save data point reached - logical record count 2980.
    default: Save data point reached - logical record count 2990.
    default: Save data point reached - logical record count 3000.
    default: Save data point reached - logical record count 3010.
    default: Save data point reached - logical record count 3020.
    default: Save data point reached - logical record count 3030.
    default: Save data point reached - logical record count 3040.
    default: Save data point reached - logical record count 3050.
    default: Save data point reached - logical record count 3060.
    default: Save data point reached - logical record count 3070.
    default: Save data point reached - logical record count 3080.
    default: Save data point reached - logical record count 3090.
    default: Save data point reached - logical record count 3100.
    default: Save data point reached - logical record count 3110.
    default: Save data point reached - logical record count 3120.
    default: Save data point reached - logical record count 3130.
    default: Save data point reached - logical record count 3140.
    default: Save data point reached - logical record count 3150.
    default: Save data point reached - logical record count 3160.
    default: Save data point reached - logical record count 3170.
    default: Save data point reached - logical record count 3180.
    default: Save data point reached - logical record count 3190.
    default: Save data point reached - logical record count 3200.
    default: Save data point reached - logical record count 3210.
    default: Save data point reached - logical record count 3220.
    default: Save data point reached - logical record count 3230.
    default: Save data point reached - logical record count 3240.
    default: Save data point reached - logical record count 3250.
    default: Save data point reached - logical record count 3260.
    default: Save data point reached - logical record count 3270.
    default: Save data point reached - logical record count 3280.
    default: Save data point reached - logical record count 3290.
    default: Save data point reached - logical record count 3300.
    default: Save data point reached - logical record count 3310.
    default: Save data point reached - logical record count 3320.
    default: Save data point reached - logical record count 3330.
    default: Save data point reached - logical record count 3340.
    default: Save data point reached - logical record count 3350.
    default: Save data point reached - logical record count 3360.
    default: Save data point reached - logical record count 3370.
    default: Save data point reached - logical record count 3380.
    default: Save data point reached - logical record count 3390.
    default: Save data point reached - logical record count 3400.
    default: Save data point reached - logical record count 3410.
    default: Save data point reached - logical record count 3420.
    default: Save data point reached - logical record count 3430.
    default: Save data point reached - logical record count 3440.
    default: Save data point reached - logical record count 3450.
    default: Save data point reached - logical record count 3460.
    default: Save data point reached - logical record count 3470.
    default: Save data point reached - logical record count 3480.
    default: Save data point reached - logical record count 3490.
    default: Save data point reached - logical record count 3500.
    default: Save data point reached - logical record count 3510.
    default: Save data point reached - logical record count 3520.
    default: Save data point reached - logical record count 3530.
    default: Save data point reached - logical record count 3540.
    default: Save data point reached - logical record count 3550.
    default: Save data point reached - logical record count 3560.
    default: Save data point reached - logical record count 3570.
    default: Save data point reached - logical record count 3580.
    default: Save data point reached - logical record count 3590.
    default: Save data point reached - logical record count 3600.
    default: Save data point reached - logical record count 3610.
    default: Save data point reached - logical record count 3620.
    default: Save data point reached - logical record count 3630.
    default: Save data point reached - logical record count 3640.
    default: Save data point reached - logical record count 3650.
    default: Save data point reached - logical record count 3660.
    default: Save data point reached - logical record count 3670.
    default: Save data point reached - logical record count 3680.
    default: Save data point reached - logical record count 3690.
    default: Save data point reached - logical record count 3700.
    default: Save data point reached - logical record count 3710.
    default: Save data point reached - logical record count 3720.
    default: Save data point reached - logical record count 3730.
    default: Save data point reached - logical record count 3740.
    default: Save data point reached - logical record count 3750.
    default: Save data point reached - logical record count 3760.
    default: Save data point reached - logical record count 3770.
    default: Save data point reached - logical record count 3780.
    default: Save data point reached - logical record count 3790.
    default: Save data point reached - logical record count 3800.
    default: Save data point reached - logical record count 3810.
    default: Save data point reached - logical record count 3820.
    default: Save data point reached - logical record count 3830.
    default: Save data point reached - logical record count 3840.
    default: Save data point reached - logical record count 3850.
    default: Save data point reached - logical record count 3860.
    default: Save data point reached - logical record count 3870.
    default: Save data point reached - logical record count 3880.
    default: Save data point reached - logical record count 3890.
    default: Save data point reached - logical record count 3900.
    default: Save data point reached - logical record count 3910.
    default: Save data point reached - logical record count 3920.
    default: Save data point reached - logical record count 3930.
    default: Save data point reached - logical record count 3940.
    default: Save data point reached - logical record count 3950.
    default: Save data point reached - logical record count 3960.
    default: Save data point reached - logical record count 3970.
    default: Save data point reached - logical record count 3980.
    default: Save data point reached - logical record count 3990.
    default: Save data point reached - logical record count 4000.
    default: Save data point reached - logical record count 4010.
    default: Save data point reached - logical record count 4020.
    default: Save data point reached - logical record count 4030.
    default: Save data point reached - logical record count 4040.
    default: Save data point reached - logical record count 4050.
    default: Save data point reached - logical record count 4060.
    default: Save data point reached - logical record count 4070.
    default: Save data point reached - logical record count 4080.
    default: Save data point reached - logical record count 4090.
    default: Save data point reached - logical record count 4100.
    default: Save data point reached - logical record count 4110.
    default: Save data point reached - logical record count 4120.
    default: Save data point reached - logical record count 4130.
    default: Save data point reached - logical record count 4140.
    default: Save data point reached - logical record count 4150.
    default: Save data point reached - logical record count 4160.
    default: Save data point reached - logical record count 4170.
    default: Save data point reached - logical record count 4180.
    default: Save data point reached - logical record count 4190.
    default: Save data point reached - logical record count 4200.
    default: Save data point reached - logical record count 4210.
    default: Save data point reached - logical record count 4220.
    default: Save data point reached - logical record count 4230.
    default: Save data point reached - logical record count 4240.
    default: Save data point reached - logical record count 4250.
    default: Save data point reached - logical record count 4260.
    default: Save data point reached - logical record count 4270.
    default: Save data point reached - logical record count 4280.
    default: Save data point reached - logical record count 4290.
    default: Save data point reached - logical record count 4300.
    default: Save data point reached - logical record count 4310.
    default: Save data point reached - logical record count 4320.
    default: Save data point reached - logical record count 4330.
    default: Save data point reached - logical record count 4340.
    default: Save data point reached - logical record count 4350.
    default: Save data point reached - logical record count 4360.
    default: Save data point reached - logical record count 4370.
    default: Save data point reached - logical record count 4380.
    default: Save data point reached - logical record count 4390.
    default: Save data point reached - logical record count 4400.
    default: Save data point reached - logical record count 4410.
    default: Save data point reached - logical record count 4420.
    default: Save data point reached - logical record count 4430.
    default: Save data point reached - logical record count 4440.
    default: Save data point reached - logical record count 4450.
    default: Save data point reached - logical record count 4460.
    default: Save data point reached - logical record count 4470.
    default: Save data point reached - logical record count 4480.
    default: Save data point reached - logical record count 4490.
    default: Save data point reached - logical record count 4500.
    default: 
    default: Load completed - logical record count 4500.
    default: 
    default: Table SUPPLEMENTARY_DEMOGRAPHICS:
    default:   4500 Rows successfully loaded.
    default: 
    default: Check the log file:
    default:   /tmp/tmp.vA7KvKRnru/log/dem1v3.log
    default: for more information about the load.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: Enabling constraints ...
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Table altered.
    default: 
    default: 
    default: Creating additional indexes ...
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Create dimensions ...
    default: 
    default: Dimension created.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: Dimension created.
    default: 
    default: 
    default: Dimension created.
    default: 
    default: 
    default: Dimension created.
    default: 
    default: 
    default: Dimension created.
    default: 
    default: Creating MVs as tables ...
    default: 
    default: 
    default: View created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Table created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: 
    default: Index created.
    default: 
    default: Creating materialized views ...
    default: 
    default: 
    default: Materialized view created.
    default: 
    default: 
    default: Materialized view created.
    default: 
    default: 
    default: Creating comments ...
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: Comment created.
    default: 
    default: 
    default: gathering statistics ...
    default: BEGIN dbms_stats.gather_table_stats(          ownname          => 'SH'                     ,          tabname          => 'SALES_TRANSACTIONS_EXT' ,          partname         => NULL                     ,          estimate_percent => NULL                     ,          block_sample     => TRUE                     ,          method_opt       => 'FOR ALL COLUMNS SIZE 1' ,          degree           => NULL                     ,          granularity      => 'ALL'                    ,          cascade          => TRUE                     ,          stattab          => NULL                     ,          statid           => NULL                     ,          statown          => NULL                     ); END;
    default: 
    default: *
    default: ERROR at line 1:
    default: ORA-29913: error while processing ODCIEXTTABLEOPEN routine
    default: ORA-06512: at "SYS.DBMS_STATS", line 41931
    default: ORA-06512: at "SYS.DBMS_STATS", line 41216
    default: ORA-06512: at "SYS.DBMS_STATS", line 40881
    default: ORA-06512: at "SYS.DBMS_STATS", line 39991
    default: ORA-06512: at "SYS.DBMS_STATS", line 38092
    default: ORA-06512: at "SYS.DBMS_STATS", line 30833
    default: ORA-29400: data cartridge error
    default: KUP-04005: error while accessing file /tmp/tmp.vA7KvKRnru/log/ext_1v3.log
    default: ORA-06512: at "SYS.DBMS_SQL", line 1806
    default: ORA-06512: at "SYS.DBMS_STATS", line 30741
    default: ORA-06512: at "SYS.DBMS_STATS", line 37820
    default: ORA-06512: at "SYS.DBMS_STATS", line 39813
    default: ORA-06512: at "SYS.DBMS_STATS", line 40861
    default: ORA-06512: at "SYS.DBMS_STATS", line 41364
    default: ORA-06512: at "SYS.DBMS_STATS", line 41912
    default: ORA-06512: at line 1
    default: 
    default: 
    default: 
    default: PL/SQL procedure successfully completed.
    default: 
    default: Connected.
    default: 
    default: specify password for BI as parameter 1:
    default: 
    default: specify default tablespeace for BI as parameter 2:
    default: 
    default: specify temporary tablespace for BI as parameter 3:
    default: 
    default: specify password for SYS as parameter 4:
    default: 
    default: specify password for OE as parameter 5:
    default: 
    default: specify password for SH as parameter 6:
    default: 
    default: specify log path as parameter 7:
    default: 
    default: specify version as parameter 8:
    default: 
    default: specify connect string as parameter 9:
    default: 
    default: Connected.
    default: DROP USER bi CASCADE
    default:           *
    default: ERROR at line 1:
    default: ORA-01918: user 'BI' does not exist
    default: 
    default: 
    default: 
    default: User created.
    default: 
    default: 
    default: User altered.
    default: 
    default: 
    default: User altered.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: specify password for oe as parameter 1:
    default: 
    default: specify connect string as parameter 2:
    default: 
    default: Connected.
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: specify password for SH as parameter 1:
    default: 
    default: specify connect string as parameter 2:
    default: 
    default: Connected.
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Grant succeeded.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: 
    default: specify password for BI as parameter 1:
    default: 
    default: specify connect string as parameter 2:
    default: 
    default: Connected.
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Synonym created.
    default: 
    default: 
    default: Commit complete.
    default: 
    default: SQL> COLUMN TABLE_NAME FORMAT A25
    default: SQL> COLUMN COLUMN_NAME FORMAT A30
    default: SQL>
    default: SQL> CONNECT bi/&pwd_bi@&connect_string;
    default: Connected.
    default: SQL>
    default: SQL> SELECT COUNT(*) FROM customers;
    default: 
    default:   COUNT(*)
    default: ----------
    default:      55500
    default: 
    default: 1 row selected.
    default: 
    default: SQL> SELECT COUNT(*) FROM products;
    default: 
    default:   COUNT(*)
    default: ----------
    default:         72
    default: 
    default: 1 row selected.
    default: 
    default: SQL> SELECT COUNT(*) FROM promotions;
    default: 
    default:   COUNT(*)
    default: ----------
    default:        503
    default: 
    default: 1 row selected.
    default: 
    default: SQL> SELECT COUNT(*) FROM sales;
    default: 
    default:   COUNT(*)
    default: ----------
    default:     918843
    default: 
    default: 1 row selected.
    default: 
    default: SQL> SELECT COUNT(*) FROM costs;
    default: 
    default:   COUNT(*)
    default: ----------
    default:          0
    default: 
    default: 1 row selected.
    default: 
    default: SQL>
    default: SQL> SELECT COUNT(*) FROM sh.cal_month_sales_mv;
    default: 
    default:   COUNT(*)
    default: ----------
    default:         48
    default: 
    default: 1 row selected.
    default: 
    default: SQL> SELECT COUNT(*) FROM sh.fweek_pscat_sales_mv;
    default: 
    default:   COUNT(*)
    default: ----------
    default:      11266
    default: 
    default: 1 row selected.
    default: 
    default: SQL>
    default: SQL> SELECT COUNT(*) FROM channels;
    default: 
    default:   COUNT(*)
    default: ----------
    default:          5
    default: 
    default: 1 row selected.
    default: 
    default: SQL> SELECT COUNT(*) FROM countries;
    default: 
    default:   COUNT(*)
    default: ----------
    default:         23
    default: 
    default: 1 row selected.
    default: 
    default: SQL> SELECT COUNT(*) FROM times;
    default: 
    default:   COUNT(*)
    default: ----------
    default:       1826
    default: 
    default: 1 row selected.
    default: 
    default: SQL>
    default: SQL> SET ECHO OFF
    default: Connected.
    default: 
    default: specify password for SYSTEM as parameter 1:
    default: 
    default: specify spool filename as parameter 2:
    default: 
    default: specify connect string as parameter 3:
    default: 
    default: Connected.
    default: 
    default: Table analyzed.
    default: 
    default: 
    default: Table analyzed.
    default: 
    default: 
    default: Table analyzed.
    default: 
    default: 
    default: Table analyzed.
    default: 
    default: 
    default: Table analyzed.
    default: 
    default: 
    default: All named objects and stati
    default: 
    default: OWNER  OBJECT_TYPE          OBJECT_NAME                    SUBOBJECT_NAME   STATUS
    default: ------ -------------------- ------------------------------ ---------------- --------
    default: BI     SYNONYM              CHANNELS                                        VALID
    default: BI     SYNONYM              COSTS                                           VALID
    default: BI     SYNONYM              COUNTRIES                                       VALID
    default: BI     SYNONYM              CUSTOMERS                                       VALID
    default: BI     SYNONYM              PRODUCTS                                        VALID
    default: BI     SYNONYM              PROMOTIONS                                      VALID
    default: BI     SYNONYM              SALES                                           VALID
    default: BI     SYNONYM              TIMES                                           VALID
    default: HR     INDEX                COUNTRY_C_ID_PK                                 VALID
    default: HR     INDEX                DEPT_ID_PK                                      VALID
    default: HR     INDEX                DEPT_LOCATION_IX                                VALID
    default: HR     INDEX                EMP_DEPARTMENT_IX                               VALID
    default: HR     INDEX                EMP_EMAIL_UK                                    VALID
    default: HR     INDEX                EMP_EMP_ID_PK                                   VALID
    default: HR     INDEX                EMP_JOB_IX                                      VALID
    default: HR     INDEX                EMP_MANAGER_IX                                  VALID
    default: HR     INDEX                EMP_NAME_IX                                     VALID
    default: HR     INDEX                JHIST_DEPARTMENT_IX                             VALID
    default: HR     INDEX                JHIST_EMPLOYEE_IX                               VALID
    default: HR     INDEX                JHIST_EMP_ID_ST_DATE_PK                         VALID
    default: HR     INDEX                JHIST_JOB_IX                                    VALID
    default: HR     INDEX                JOB_ID_PK                                       VALID
    default: HR     INDEX                LOC_CITY_IX                                     VALID
    default: HR     INDEX                LOC_COUNTRY_IX                                  VALID
    default: HR     INDEX                LOC_ID_PK                                       VALID
    default: HR     INDEX                LOC_STATE_PROVINCE_IX                           VALID
    default: HR     INDEX                REG_ID_PK                                       VALID
    default: HR     PROCEDURE            ADD_JOB_HISTORY                                 VALID
    default: HR     PROCEDURE            SECURE_DML                                      VALID
    default: HR     SEQUENCE             DEPARTMENTS_SEQ                                 VALID
    default: HR     SEQUENCE             EMPLOYEES_SEQ                                   VALID
    default: HR     SEQUENCE             LOCATIONS_SEQ                                   VALID
    default: HR     TABLE                COUNTRIES                                       VALID
    default: HR     TABLE                DEPARTMENTS                                     VALID
    default: HR     TABLE                EMPLOYEES                                       VALID
    default: HR     TABLE                JOBS                                            VALID
    default: HR     TABLE                JOB_HISTORY                                     VALID
    default: HR     TABLE                LOCATIONS                                       VALID
    default: HR     TABLE                REGIONS                                         VALID
    default: HR     TRIGGER              SECURE_EMPLOYEES                                VALID
    default: HR     TRIGGER              UPDATE_JOB_HISTORY                              VALID
    default: HR     VIEW                 EMP_DETAILS_VIEW                                VALID
    default: IX     EVALUATION CONTEXT   AQ$_ORDERS_QUEUETABLE_V                         VALID
    default: IX     EVALUATION CONTEXT   AQ$_STREAMS_QUEUE_TABLE_V                       VALID
    default: IX     INDEX                AQ$_STREAMS_QUEUE_TABLE_Y                       VALID
    default: IX     QUEUE                AQ$_ORDERS_QUEUETABLE_E                         VALID
    default: IX     QUEUE                AQ$_STREAMS_QUEUE_TABLE_E                       VALID
    default: IX     QUEUE                ORDERS_QUEUE                                    VALID
    default: IX     QUEUE                STREAMS_QUEUE                                   VALID
    default: IX     RULE SET             ORDERS_QUEUE_N                                  VALID
    default: IX     RULE SET             ORDERS_QUEUE_R                                  VALID
    default: IX     RULE SET             STREAMS_QUEUE_N                                 VALID
    default: IX     RULE SET             STREAMS_QUEUE_R                                 VALID
    default: IX     SEQUENCE             AQ$_ORDERS_QUEUETABLE_N                         VALID
    default: IX     SEQUENCE             AQ$_STREAMS_QUEUE_TABLE_N                       VALID
    default: IX     TABLE                AQ$_ORDERS_QUEUETABLE_G                         VALID
    default: IX     TABLE                AQ$_ORDERS_QUEUETABLE_H                         VALID
    default: IX     TABLE                AQ$_ORDERS_QUEUETABLE_I                         VALID
    default: IX     TABLE                AQ$_ORDERS_QUEUETABLE_L                         VALID
    default: IX     TABLE                AQ$_ORDERS_QUEUETABLE_S                         VALID
    default: IX     TABLE                AQ$_ORDERS_QUEUETABLE_T                         VALID
    default: IX     TABLE                AQ$_STREAMS_QUEUE_TABLE_C                       VALID
    default: IX     TABLE                AQ$_STREAMS_QUEUE_TABLE_G                       VALID
    default: IX     TABLE                AQ$_STREAMS_QUEUE_TABLE_H                       VALID
    default: IX     TABLE                AQ$_STREAMS_QUEUE_TABLE_I                       VALID
    default: IX     TABLE                AQ$_STREAMS_QUEUE_TABLE_L                       VALID
    default: IX     TABLE                AQ$_STREAMS_QUEUE_TABLE_S                       VALID
    default: IX     TABLE                AQ$_STREAMS_QUEUE_TABLE_T                       VALID
    default: IX     TABLE                ORDERS_QUEUETABLE                               VALID
    default: IX     TABLE                STREAMS_QUEUE_TABLE                             VALID
    default: IX     TYPE                 ORDER_EVENT_TYP                                 VALID
    default: IX     VIEW                 AQ$ORDERS_QUEUETABLE                            VALID
    default: IX     VIEW                 AQ$ORDERS_QUEUETABLE_R                          VALID
    default: IX     VIEW                 AQ$ORDERS_QUEUETABLE_S                          VALID
    default: IX     VIEW                 AQ$STREAMS_QUEUE_TABLE                          VALID
    default: IX     VIEW                 AQ$STREAMS_QUEUE_TABLE_R                        VALID
    default: IX     VIEW                 AQ$STREAMS_QUEUE_TABLE_S                        VALID
    default: IX     VIEW                 AQ$_ORDERS_QUEUETABLE_F                         VALID
    default: IX     VIEW                 AQ$_STREAMS_QUEUE_TABLE_F                       VALID
    default: OE     FUNCTION             GET_PHONE_NUMBER_F                              VALID
    default: OE     INDEX                ACTION_TABLE_MEMBERS                            VALID
    default: OE     INDEX                CUSTOMERS_PK                                    VALID
    default: OE     INDEX                CUST_ACCOUNT_MANAGER_IX                         VALID
    default: OE     INDEX                CUST_EMAIL_IX                                   VALID
    default: OE     INDEX                CUST_LNAME_IX                                   VALID
    default: OE     INDEX                CUST_UPPER_NAME_IX                              VALID
    default: OE     INDEX                INVENTORY_IX                                    VALID
    default: OE     INDEX                INV_PRODUCT_IX                                  VALID
    default: OE     INDEX                ITEM_ORDER_IX                                   VALID
    default: OE     INDEX                ITEM_PRODUCT_IX                                 VALID
    default: OE     INDEX                LINEITEM_TABLE_MEMBERS                          VALID
    default: OE     INDEX                ORDER_ITEMS_PK                                  VALID
    default: OE     INDEX                ORDER_ITEMS_UK                                  VALID
    default: OE     INDEX                ORDER_PK                                        VALID
    default: OE     INDEX                ORD_CUSTOMER_IX                                 VALID
    default: OE     INDEX                ORD_ORDER_DATE_IX                               VALID
    default: OE     INDEX                ORD_SALES_REP_IX                                VALID
    default: OE     INDEX                PRD_DESC_PK                                     VALID
    default: OE     INDEX                PRODUCT_INFORMATION_PK                          VALID
    default: OE     INDEX                PROD_NAME_IX                                    VALID
    default: OE     INDEX                PROD_SUPPLIER_IX                                VALID
    default: OE     INDEX                PROMO_ID_PK                                     VALID
    default: OE     INDEX                WAREHOUSES_PK                                   VALID
    default: OE     INDEX                WHS_LOCATION_IX                                 VALID
    default: OE     LOB                  EXTRADATA26_L                                   VALID
    default: OE     LOB                  NAMESPACES27_L                                  VALID
    default: OE     SEQUENCE             ORDERS_SEQ                                      VALID
    default: OE     SYNONYM              COUNTRIES                                       VALID
    default: OE     SYNONYM              DEPARTMENTS                                     VALID
    default: OE     SYNONYM              EMPLOYEES                                       VALID
    default: OE     SYNONYM              JOBS                                            VALID
    default: OE     SYNONYM              JOB_HISTORY                                     VALID
    default: OE     SYNONYM              LOCATIONS                                       VALID
    default: OE     TABLE                ACTION_TABLE                                    VALID
    default: OE     TABLE                CATEGORIES_TAB                                  VALID
    default: OE     TABLE                CUSTOMERS                                       VALID
    default: OE     TABLE                INVENTORIES                                     VALID
    default: OE     TABLE                LINEITEM_TABLE                                  VALID
    default: OE     TABLE                ORDERS                                          VALID
    default: OE     TABLE                ORDER_ITEMS                                     VALID
    default: OE     TABLE                PRODUCT_DESCRIPTIONS                            VALID
    default: OE     TABLE                PRODUCT_INFORMATION                             VALID
    default: OE     TABLE                PRODUCT_REF_LIST_NESTEDTAB                      VALID
    default: OE     TABLE                PROMOTIONS                                      VALID
    default: OE     TABLE                PURCHASEORDER                                   VALID
    default: OE     TABLE                SUBCATEGORY_REF_LIST_NESTEDTAB                  VALID
    default: OE     TABLE                WAREHOUSES                                      VALID
    default: OE     TRIGGER              INSERT_ORD_LINE                                 VALID
    default: OE     TRIGGER              ORDERS_ITEMS_TRG                                VALID
    default: OE     TRIGGER              ORDERS_TRG                                      VALID
    default: OE     TRIGGER              PURCHASEORDER$xd                                VALID
    default: OE     TYPE                 ACTIONS_T                                       VALID
    default: OE     TYPE                 ACTION_T                                        VALID
    default: OE     TYPE                 ACTION_V                                        VALID
    default: OE     TYPE                 CATALOG_TYP                    $VSN_1           VALID
    default: OE     TYPE                 CATALOG_TYP                                     VALID
    default: OE     TYPE                 CATEGORY_TYP                   $VSN_1           VALID
    default: OE     TYPE                 CATEGORY_TYP                                    VALID
    default: OE     TYPE                 COMPOSITE_CATEGORY_TYP         $VSN_1           VALID
    default: OE     TYPE                 COMPOSITE_CATEGORY_TYP                          VALID
    default: OE     TYPE                 CORPORATE_CUSTOMER_TYP                          VALID
    default: OE     TYPE                 CUSTOMER_TYP                                    VALID
    default: OE     TYPE                 CUST_ADDRESS_TYP                                VALID
    default: OE     TYPE                 INVENTORY_LIST_TYP                              VALID
    default: OE     TYPE                 INVENTORY_TYP                                   VALID
    default: OE     TYPE                 LEAF_CATEGORY_TYP              $VSN_1           VALID
    default: OE     TYPE                 LEAF_CATEGORY_TYP                               VALID
    default: OE     TYPE                 LINEITEMS_T                                     VALID
    default: OE     TYPE                 LINEITEM_T                                      VALID
    default: OE     TYPE                 LINEITEM_V                                      VALID
    default: OE     TYPE                 ORDER_ITEM_LIST_TYP                             VALID
    default: OE     TYPE                 ORDER_ITEM_TYP                                  VALID
    default: OE     TYPE                 ORDER_LIST_TYP                                  VALID
    default: OE     TYPE                 ORDER_TYP                                       VALID
    default: OE     TYPE                 PART_T                                          VALID
    default: OE     TYPE                 PHONE_LIST_TYP                                  VALID
    default: OE     TYPE                 PRODUCT_INFORMATION_TYP                         VALID
    default: OE     TYPE                 PRODUCT_REF_LIST_TYP                            VALID
    default: OE     TYPE                 PURCHASEORDER_T                                 VALID
    default: OE     TYPE                 REJECTION_T                                     VALID
    default: OE     TYPE                 SHIPPING_INSTRUCTIONS_T                         VALID
    default: OE     TYPE                 SUBCATEGORY_REF_LIST_TYP                        VALID
    default: OE     TYPE                 WAREHOUSE_TYP                                   VALID
    default: OE     TYPE BODY            CATALOG_TYP                                     VALID
    default: OE     TYPE BODY            COMPOSITE_CATEGORY_TYP                          VALID
    default: OE     TYPE BODY            LEAF_CATEGORY_TYP                               VALID
    default: OE     VIEW                 ACCOUNT_MANAGERS                                VALID
    default: OE     VIEW                 BOMBAY_INVENTORY                                VALID
    default: OE     VIEW                 CUSTOMERS_VIEW                                  VALID
    default: OE     VIEW                 OC_CORPORATE_CUSTOMERS                          VALID
    default: OE     VIEW                 OC_CUSTOMERS                                    VALID
    default: OE     VIEW                 OC_INVENTORIES                                  VALID
    default: OE     VIEW                 OC_ORDERS                                       VALID
    default: OE     VIEW                 OC_PRODUCT_INFORMATION                          VALID
    default: OE     VIEW                 ORDERS_VIEW                                     VALID
    default: OE     VIEW                 PRODUCTS                                        VALID
    default: OE     VIEW                 PRODUCT_PRICES                                  VALID
    default: OE     VIEW                 SYDNEY_INVENTORY                                VALID
    default: OE     VIEW                 TORONTO_INVENTORY                               VALID
    default: PM     INDEX                PRINTMEDIA_PK                                   VALID
    default: PM     TABLE                PRINT_MEDIA                                     VALID
    default: PM     TABLE                TEXTDOCS_NESTEDTAB                              VALID
    default: PM     TYPE                 ADHEADER_TYP                                    VALID
    default: PM     TYPE                 TEXTDOC_TAB                                     VALID
    default: PM     TYPE                 TEXTDOC_TYP                                     VALID
    default: SH     DIMENSION            CHANNELS_DIM                                    VALID
    default: SH     DIMENSION            CUSTOMERS_DIM                                   VALID
    default: SH     DIMENSION            PRODUCTS_DIM                                    VALID
    default: SH     DIMENSION            PROMOTIONS_DIM                                  VALID
    default: SH     DIMENSION            TIMES_DIM                                       VALID
    default: SH     INDEX                CHANNELS_PK                                     VALID
    default: SH     INDEX                COSTS_PROD_BIX                                  VALID
    default: SH     INDEX                COSTS_TIME_BIX                                  VALID
    default: SH     INDEX                COUNTRIES_PK                                    VALID
    default: SH     INDEX                CUSTOMERS_GENDER_BIX                            VALID
    default: SH     INDEX                CUSTOMERS_MARITAL_BIX                           VALID
    default: SH     INDEX                CUSTOMERS_PK                                    VALID
    default: SH     INDEX                CUSTOMERS_YOB_BIX                               VALID
    default: SH     INDEX                DR$SUP_TEXT_IDX$KD                              VALID
    default: SH     INDEX                DR$SUP_TEXT_IDX$KR                              VALID
    default: SH     INDEX                DR$SUP_TEXT_IDX$X                               VALID
    default: SH     INDEX                FW_PSC_S_MV_CHAN_BIX                            VALID
    default: SH     INDEX                FW_PSC_S_MV_PROMO_BIX                           VALID
    default: SH     INDEX                FW_PSC_S_MV_SUBCAT_BIX                          VALID
    default: SH     INDEX                FW_PSC_S_MV_WD_BIX                              VALID
    default: SH     INDEX                PRODUCTS_PK                                     VALID
    default: SH     INDEX                PRODUCTS_PROD_CAT_IX                            VALID
    default: SH     INDEX                PRODUCTS_PROD_STATUS_BIX                        VALID
    default: SH     INDEX                PRODUCTS_PROD_SUBCAT_IX                         VALID
    default: SH     INDEX                PROMO_PK                                        VALID
    default: SH     INDEX                SALES_CHANNEL_BIX                               VALID
    default: SH     INDEX                SALES_CUST_BIX                                  VALID
    default: SH     INDEX                SALES_PROD_BIX                                  VALID
    default: SH     INDEX                SALES_PROMO_BIX                                 VALID
    default: SH     INDEX                SALES_TIME_BIX                                  VALID
    default: SH     INDEX                SUP_TEXT_IDX                                    VALID
    default: SH     INDEX                TIMES_PK                                        VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_1995       VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_1996       VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_H1_1997    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_H2_1997    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q1_1998    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q1_1999    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q1_2000    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q1_2001    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q1_2002    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q1_2003    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q2_1998    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q2_1999    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q2_2000    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q2_2001    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q2_2002    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q2_2003    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q3_1998    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q3_1999    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q3_2000    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q3_2001    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q3_2002    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q3_2003    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q4_1998    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q4_1999    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q4_2000    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q4_2001    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q4_2002    VALID
    default: SH     INDEX PARTITION      COSTS_PROD_BIX                 COSTS_Q4_2003    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_1995       VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_1996       VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_H1_1997    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_H2_1997    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q1_1998    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q1_1999    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q1_2000    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q1_2001    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q1_2002    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q1_2003    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q2_1998    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q2_1999    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q2_2000    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q2_2001    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q2_2002    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q2_2003    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q3_1998    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q3_1999    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q3_2000    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q3_2001    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q3_2002    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q3_2003    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q4_1998    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q4_1999    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q4_2000    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q4_2001    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q4_2002    VALID
    default: SH     INDEX PARTITION      COSTS_TIME_BIX                 COSTS_Q4_2003    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_1995       VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_1996       VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_H1_1997    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_H2_1997    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q1_1998    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q1_1999    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q1_2000    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q1_2001    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q1_2002    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q1_2003    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q2_1998    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q2_1999    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q2_2000    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q2_2001    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q2_2002    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q2_2003    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q3_1998    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q3_1999    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q3_2000    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q3_2001    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q3_2002    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q3_2003    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q4_1998    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q4_1999    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q4_2000    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q4_2001    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q4_2002    VALID
    default: SH     INDEX PARTITION      SALES_CHANNEL_BIX              SALES_Q4_2003    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_1995       VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_1996       VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_H1_1997    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_H2_1997    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q1_1998    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q1_1999    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q1_2000    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q1_2001    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q1_2002    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q1_2003    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q2_1998    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q2_1999    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q2_2000    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q2_2001    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q2_2002    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q2_2003    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q3_1998    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q3_1999    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q3_2000    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q3_2001    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q3_2002    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q3_2003    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q4_1998    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q4_1999    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q4_2000    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q4_2001    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q4_2002    VALID
    default: SH     INDEX PARTITION      SALES_CUST_BIX                 SALES_Q4_2003    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_1995       VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_1996       VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_H1_1997    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_H2_1997    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q1_1998    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q1_1999    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q1_2000    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q1_2001    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q1_2002    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q1_2003    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q2_1998    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q2_1999    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q2_2000    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q2_2001    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q2_2002    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q2_2003    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q3_1998    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q3_1999    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q3_2000    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q3_2001    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q3_2002    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q3_2003    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q4_1998    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q4_1999    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q4_2000    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q4_2001    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q4_2002    VALID
    default: SH     INDEX PARTITION      SALES_PROD_BIX                 SALES_Q4_2003    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_1995       VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_1996       VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_H1_1997    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_H2_1997    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q1_1998    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q1_1999    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q1_2000    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q1_2001    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q1_2002    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q1_2003    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q2_1998    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q2_1999    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q2_2000    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q2_2001    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q2_2002    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q2_2003    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q3_1998    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q3_1999    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q3_2000    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q3_2001    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q3_2002    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q3_2003    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q4_1998    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q4_1999    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q4_2000    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q4_2001    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q4_2002    VALID
    default: SH     INDEX PARTITION      SALES_PROMO_BIX                SALES_Q4_2003    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_1995       VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_1996       VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_H1_1997    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_H2_1997    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q1_1998    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q1_1999    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q1_2000    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q1_2001    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q1_2002    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q1_2003    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q2_1998    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q2_1999    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q2_2000    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q2_2001    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q2_2002    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q2_2003    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q3_1998    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q3_1999    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q3_2000    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q3_2001    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q3_2002    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q3_2003    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q4_1998    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q4_1999    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q4_2000    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q4_2001    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q4_2002    VALID
    default: SH     INDEX PARTITION      SALES_TIME_BIX                 SALES_Q4_2003    VALID
    default: SH     MATERIALIZED VIEW    CAL_MONTH_SALES_MV                              VALID
    default: SH     MATERIALIZED VIEW    FWEEK_PSCAT_SALES_MV                            VALID
    default: SH     TABLE                CAL_MONTH_SALES_MV                              VALID
    default: SH     TABLE                CHANNELS                                        VALID
    default: SH     TABLE                COSTS                                           VALID
    default: SH     TABLE                COUNTRIES                                       VALID
    default: SH     TABLE                CUSTOMERS                                       VALID
    default: SH     TABLE                DR$SUP_TEXT_IDX$B                               VALID
    default: SH     TABLE                DR$SUP_TEXT_IDX$C                               VALID
    default: SH     TABLE                DR$SUP_TEXT_IDX$I                               VALID
    default: SH     TABLE                DR$SUP_TEXT_IDX$K                               VALID
    default: SH     TABLE                DR$SUP_TEXT_IDX$N                               VALID
    default: SH     TABLE                DR$SUP_TEXT_IDX$Q                               VALID
    default: SH     TABLE                DR$SUP_TEXT_IDX$U                               VALID
    default: SH     TABLE                FWEEK_PSCAT_SALES_MV                            VALID
    default: SH     TABLE                PRODUCTS                                        VALID
    default: SH     TABLE                PROMOTIONS                                      VALID
    default: SH     TABLE                SALES                                           VALID
    default: SH     TABLE                SALES_TRANSACTIONS_EXT                          VALID
    default: SH     TABLE                SUPPLEMENTARY_DEMOGRAPHICS                      VALID
    default: SH     TABLE                TIMES                                           VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_1995       VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_1996       VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_H1_1997    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_H2_1997    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q1_1998    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q1_1999    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q1_2000    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q1_2001    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q1_2002    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q1_2003    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q2_1998    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q2_1999    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q2_2000    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q2_2001    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q2_2002    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q2_2003    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q3_1998    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q3_1999    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q3_2000    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q3_2001    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q3_2002    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q3_2003    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q4_1998    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q4_1999    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q4_2000    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q4_2001    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q4_2002    VALID
    default: SH     TABLE PARTITION      COSTS                          COSTS_Q4_2003    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_1995       VALID
    default: SH     TABLE PARTITION      SALES                          SALES_1996       VALID
    default: SH     TABLE PARTITION      SALES                          SALES_H1_1997    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_H2_1997    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q1_1998    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q1_1999    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q1_2000    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q1_2001    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q1_2002    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q1_2003    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q2_1998    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q2_1999    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q2_2000    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q2_2001    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q2_2002    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q2_2003    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q3_1998    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q3_1999    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q3_2000    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q3_2001    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q3_2002    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q3_2003    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q4_1998    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q4_1999    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q4_2000    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q4_2001    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q4_2002    VALID
    default: SH     TABLE PARTITION      SALES                          SALES_Q4_2003    VALID
    default: SH     VIEW                 PROFITS                                         VALID
    default: 
    default: 491 rows selected.
    default: 
    default: 
    default: Data types used
    default: 
    default: OWNER  DATA_TYPE                           DATA_TYPE_OWNER  DAT   COUNT(*)
    default: ------ ----------------------------------- ---------------- --- ----------
    default: PM     ADHEADER_TYP                        PM                            1
    default: IX     ANYDATA                             SYS                           7
    default: IX     AQ$_SIG_PROP                        SYS                           4
    default: PM     BFILE                                                             1
    default: PM     BLOB                                                              2
    default: SH     BLOB                                                              1
    default: HR     CHAR                                                              3
    default: IX     CHAR                                                              2
    default: OE     CHAR                                                              2
    default: SH     CHAR                                                              5
    default: IX     CLOB                                                              2
    default: PM     CLOB                                                              2
    default: OE     CUSTOMER_TYP                        OE               REF          1
    default: OE     CUST_ADDRESS_TYP                    OE                            3
    default: HR     DATE                                                              3
    default: IX     DATE                                                              6
    default: OE     DATE                                                              2
    default: SH     DATE                                                             19
    default: OE     INTERVAL YEAR(2) TO MONTH                                         3
    default: OE     INVENTORY_LIST_TYP                  OE                            1
    default: PM     NCLOB                                                             1
    default: HR     NUMBER                                                           21
    default: IX     NUMBER                                                          107
    default: OE     NUMBER                                                           80
    default: PM     NUMBER                                                            2
    default: SH     NUMBER                                                          108
    default: OE     NVARCHAR2                                                         7
    default: IX     ORDER_EVENT_TYP                     IX                            3
    default: OE     ORDER_ITEM_LIST_TYP                 OE                            1
    default: OE     ORDER_LIST_TYP                      OE                            2
    default: OE     PHONE_LIST_TYP                      OE                            3
    default: IX     RAW                                                              32
    default: IX     ROWID                                                             6
    default: SH     ROWID                                                             4
    default: OE     SDO_GEOMETRY                        MDSYS                         2
    default: PM     TEXTDOC_TAB                         PM                            1
    default: IX     TIMESTAMP(6)                                                     25
    default: OE     TIMESTAMP(6) WITH LOCAL TIME ZONE                                 1
    default: IX     TIMESTAMP(6) WITH TIME ZONE                                       8
    default: IX     TIMESTAMP(9)                                                      2
    default: HR     VARCHAR2                                                         24
    default: IX     VARCHAR2                                                        128
    default: OE     VARCHAR2                                                         53
    default: SH     VARCHAR2                                                         47
    default: OE     WAREHOUSE_TYP                       OE                            1
    default: OE     XMLTYPE                             SYS                           2
    default: 
    default: 46 rows selected.
    default: 
    default: 
    default: XML tables
    default: 
    default: OWNER  TABLE_NAME                     SCHEMA_OWNER     STORAGE_TYPE
    default: ------ ------------------------------ ---------------- --------------------
    default: OE     PURCHASEORDER                  OE               OBJECT-RELATIONAL
    default: 
    default: 1 row selected.
    default: 
    default: 
    default: All objects named 'SYS%' (LOBs etc)
    default: 
    default: OWNER  OBJECT_TYPE          STATUS     COUNT(*)
    default: ------ -------------------- -------- ----------
    default: IX     INDEX                VALID            16
    default: OE     INDEX                VALID            24
    default: PM     INDEX                VALID             9
    default: SH     INDEX                VALID             3
    default: IX     LOB                  VALID             3
    default: OE     LOB                  VALID            13
    default: PM     LOB                  VALID             7
    default: SH     LOB                  VALID             1
    default: IX     TABLE                VALID             2
    default: OE     TYPE                 VALID             5
    default: 
    default: 10 rows selected.
    default: 
    default: 
    default: All constraints
    default: 
    default: OWNER  CONSTRAINT_TYPE      STATUS   VALIDATED        GENERATED          COUNT(*)
    default: ------ -------------------- -------- ---------------- ---------------- ----------
    default: IX     Check or Not Null    ENABLED  VALIDATED        GENERATED NAME            4
    default: OE     Check or Not Null    ENABLED  VALIDATED        GENERATED NAME            2
    default: SH     Check or Not Null    ENABLED  VALIDATED        GENERATED NAME          121
    default: HR     Check or Not Null    ENABLED  VALIDATED        USER NAME                15
    default: OE     Check or Not Null    ENABLED  VALIDATED        USER NAME                13
    default: SH     Foreign key          DISABLED NOT VALIDATED    USER NAME                 2
    default: OE     Foreign key          ENABLED  NOT VALIDATED    USER NAME                 2
    default: SH     Foreign key          ENABLED  NOT VALIDATED    USER NAME                 8
    default: HR     Foreign key          ENABLED  VALIDATED        USER NAME                10
    default: OE     Foreign key          ENABLED  VALIDATED        USER NAME                 7
    default: PM     Foreign key          ENABLED  VALIDATED        USER NAME                 1
    default: SH     Primary key          DISABLED NOT VALIDATED    USER NAME                 1
    default: SH     Primary key          ENABLED  NOT VALIDATED    USER NAME                 6
    default: IX     Primary key          ENABLED  VALIDATED        GENERATED NAME           13
    default: OE     Primary key          ENABLED  VALIDATED        GENERATED NAME            3
    default: SH     Primary key          ENABLED  VALIDATED        GENERATED NAME            2
    default: HR     Primary key          ENABLED  VALIDATED        USER NAME                 7
    default: OE     Primary key          ENABLED  VALIDATED        USER NAME                 8
    default: PM     Primary key          ENABLED  VALIDATED        USER NAME                 1
    default: HR     Read only view       ENABLED  NOT VALIDATED    GENERATED NAME            1
    default: IX     Read only view       ENABLED  NOT VALIDATED    GENERATED NAME            8
    default: OE     Unique key           ENABLED  VALIDATED        GENERATED NAME            6
    default: PM     Unique key           ENABLED  VALIDATED        GENERATED NAME            1
    default: HR     Unique key           ENABLED  VALIDATED        USER NAME                 1
    default: 
    default: 24 rows selected.
    default: 
    default: 
    default: All dimensions
    default: 
    default: OWNER  DIMENSION_NAME       I COMPILE_STATE
    default: ------ -------------------- - -------------
    default: SH     CHANNELS_DIM         N VALID
    default: SH     CUSTOMERS_DIM        N VALID
    default: SH     PRODUCTS_DIM         N VALID
    default: SH     PROMOTIONS_DIM       N VALID
    default: SH     TIMES_DIM            N VALID
    default: 
    default: 5 rows selected.
    default: 
    default: 
    default: All granted roles
    default: 
    default: GRANTED_ROLE              GRANTEE
    default: ------------------------- -------
    default: AQ_ADMINISTRATOR_ROLE     IX
    default: AQ_USER_ROLE              IX
    default: CONNECT                   IX
    default: CONNECT                   PM
    default: RESOURCE                  BI
    default: RESOURCE                  HR
    default: RESOURCE                  IX
    default: RESOURCE                  OE
    default: RESOURCE                  PM
    default: RESOURCE                  SH
    default: SELECT_CATALOG_ROLE       IX
    default: SELECT_CATALOG_ROLE       SH
    default: XDBADMIN                  OE
    default: 
    default: 13 rows selected.
    default: 
    default: 
    default: All granted system privileges
    default: 
    default: PRIVILEGE                 GRANTEE
    default: ------------------------- -------
    default: ALTER SESSION             BI
    default: ALTER SESSION             HR
    default: ALTER SESSION             IX
    default: ALTER SESSION             SH
    default: CREATE CLUSTER            BI
    default: CREATE CLUSTER            IX
    default: CREATE CLUSTER            SH
    default: CREATE DATABASE LINK      BI
    default: CREATE DATABASE LINK      HR
    default: CREATE DATABASE LINK      IX
    default: CREATE DATABASE LINK      OE
    default: CREATE DATABASE LINK      SH
    default: CREATE DIMENSION          SH
    default: CREATE INDEXTYPE          IX
    default: CREATE MATERIALIZED VIEW  OE
    default: CREATE MATERIALIZED VIEW  SH
    default: CREATE OPERATOR           IX
    default: CREATE PROCEDURE          IX
    default: CREATE RULE               IX
    default: CREATE RULE SET           IX
    default: CREATE SEQUENCE           BI
    default: CREATE SEQUENCE           HR
    default: CREATE SEQUENCE           IX
    default: CREATE SEQUENCE           SH
    default: CREATE SESSION            BI
    default: CREATE SESSION            HR
    default: CREATE SESSION            IX
    default: CREATE SESSION            OE
    default: CREATE SESSION            SH
    default: CREATE SYNONYM            BI
    default: CREATE SYNONYM            HR
    default: CREATE SYNONYM            IX
    default: CREATE SYNONYM            OE
    default: CREATE SYNONYM            SH
    default: CREATE TABLE              BI
    default: CREATE TABLE              IX
    default: CREATE TABLE              SH
    default: CREATE TRIGGER            IX
    default: CREATE TYPE               IX
    default: CREATE VIEW               BI
    default: CREATE VIEW               HR
    default: CREATE VIEW               IX
    default: CREATE VIEW               OE
    default: CREATE VIEW               SH
    default: QUERY REWRITE             OE
    default: QUERY REWRITE             SH
    default: SELECT ANY DICTIONARY     IX
    default: UNLIMITED TABLESPACE      BI
    default: UNLIMITED TABLESPACE      HR
    default: UNLIMITED TABLESPACE      IX
    default: UNLIMITED TABLESPACE      OE
    default: UNLIMITED TABLESPACE      PM
    default: UNLIMITED TABLESPACE      SH
    default: 
    default: 53 rows selected.
    default: 
    default: 
    default: All granted object privileges
    default: 
    default: OWNER  TABLE_NAME                     PRIVILEGE                 GRANTEE
    default: ------ ------------------------------ ------------------------- -------
    default: HR     COUNTRIES                      REFERENCES                OE
    default: HR     COUNTRIES                      SELECT                    OE
    default: HR     DEPARTMENTS                    SELECT                    OE
    default: HR     EMPLOYEES                      REFERENCES                OE
    default: HR     EMPLOYEES                      SELECT                    OE
    default: HR     JOBS                           SELECT                    OE
    default: HR     JOB_HISTORY                    SELECT                    OE
    default: HR     LOCATIONS                      REFERENCES                OE
    default: HR     LOCATIONS                      SELECT                    OE
    default: OE     BOMBAY_INVENTORY               SELECT                    BI
    default: OE     CUSTOMERS                      SELECT                    BI
    default: OE     CUSTOMERS                      SELECT                    PM
    default: OE     INVENTORIES                    SELECT                    BI
    default: OE     INVENTORIES                    SELECT                    PM
    default: OE     ORDERS                         SELECT                    BI
    default: OE     ORDERS                         SELECT                    PM
    default: OE     ORDER_ITEMS                    SELECT                    BI
    default: OE     ORDER_ITEMS                    SELECT                    PM
    default: OE     PRODUCTS                       SELECT                    BI
    default: OE     PRODUCT_DESCRIPTIONS           SELECT                    BI
    default: OE     PRODUCT_DESCRIPTIONS           SELECT                    PM
    default: OE     PRODUCT_INFORMATION            REFERENCES                PM
    default: OE     PRODUCT_INFORMATION            SELECT                    BI
    default: OE     PRODUCT_INFORMATION            SELECT                    PM
    default: OE     PRODUCT_PRICES                 SELECT                    BI
    default: OE     PROMOTIONS                     SELECT                    BI
    default: OE     SYDNEY_INVENTORY               SELECT                    BI
    default: OE     TORONTO_INVENTORY              SELECT                    BI
    default: OE     WAREHOUSES                     SELECT                    BI
    default: OE     WAREHOUSES                     SELECT                    PM
    default: SH     CAL_MONTH_SALES_MV             SELECT                    BI
    default: SH     CHANNELS                       SELECT                    BI
    default: SH     COSTS                          SELECT                    BI
    default: SH     COUNTRIES                      SELECT                    BI
    default: SH     CUSTOMERS                      SELECT                    BI
    default: SH     FWEEK_PSCAT_SALES_MV           SELECT                    BI
    default: SH     PRODUCTS                       SELECT                    BI
    default: SH     PROMOTIONS                     SELECT                    BI
    default: SH     SALES                          SELECT                    BI
    default: SH     TIMES                          SELECT                    BI
    default: SYS    AQ$_UNFLUSHED_DEQUEUES         SELECT                    IX
    default: SYS    DATA_FILE_DIR                  READ                      SH
    default: SYS    DBMS_APPLY_ADM                 EXECUTE                   IX
    default: SYS    DBMS_AQ                        EXECUTE                   IX
    default: SYS    DBMS_AQADM                     EXECUTE                   IX
    default: SYS    DBMS_AQ_BQVIEW                 EXECUTE                   IX
    default: SYS    DBMS_CAPTURE_ADM               EXECUTE                   IX
    default: SYS    DBMS_FLASHBACK                 EXECUTE                   IX
    default: SYS    DBMS_PROPAGATION_ADM           EXECUTE                   IX
    default: SYS    DBMS_STATS                     EXECUTE                   HR
    default: SYS    DBMS_STATS                     EXECUTE                   IX
    default: SYS    DBMS_STATS                     EXECUTE                   OE
    default: SYS    DBMS_STATS                     EXECUTE                   PM
    default: SYS    DBMS_STATS                     EXECUTE                   SH
    default: SYS    DBMS_STREAMS_ADM               EXECUTE                   IX
    default: SYS    LOG_FILE_DIR                   READ                      SH
    default: SYS    LOG_FILE_DIR                   WRITE                     SH
    default: SYS    MEDIA_DIR                      READ                      PM
    default: SYS    QT78086_BUFFER                 SELECT                    IX
    default: SYS    QT78113_BUFFER                 SELECT                    IX
    default: SYS    SS_OE_XMLDIR                   READ                      OE
    default: SYS    SS_OE_XMLDIR                   WRITE                     OE
    default: SYS    SUBDIR                         READ                      OE
    default: SYS    SUBDIR                         WRITE                     OE
    default: 
    default: 64 rows selected.
    default: 
    default: 
    default: Space usage
    default: 
    default: OWNER  SEGMENT_TYPE         SUM(BYTES)
    default: ------ -------------------- ----------
    default: HR     TABLE                    393216
    default: HR     INDEX                   1245184
    default: OE     TABLE                   3932160
    default: OE     LOBINDEX                 983040
    default: OE     LOBSEGMENT              3932160
    default: OE     INDEX                   3014656
    default: OE     NESTED TABLE             589824
    default: PM     TABLE                     65536
    default: PM     NESTED TABLE              65536
    default: PM     INDEX                    196608
    default: PM     LOBINDEX                 458752
    default: PM     LOBSEGMENT              6225920
    default: IX     TABLE                    524288
    default: IX     INDEX                    917504
    default: IX     LOBINDEX                 196608
    default: IX     LOBSEGMENT               786432
    default: SH     TABLE PARTITION       134217728
    default: SH     TABLE                  20054016
    default: SH     INDEX                   2555904
    default: SH     INDEX PARTITION         9043968
    default: SH     LOBINDEX                  65536
    default: SH     LOBSEGMENT               262144
    default: HR                             1638400
    default: OE                            12451840
    default: PM                             7012352
    default: IX                             2424832
    default: SH                           166199296
    default:                              189726720
    default: 
    default: 28 rows selected.
    default: 
    default: 
    default: Table cardinality relational and object tables
    default: 
    default: OWNER  TABLE_NAME                       NUM_ROWS
    default: ------ ------------------------------ ----------
    default: HR     COUNTRIES                              25
    default: HR     DEPARTMENTS                            27
    default: HR     EMPLOYEES                             107
    default: HR     JOBS                                   19
    default: HR     JOB_HISTORY                            10
    default: HR     LOCATIONS                              23
    default: HR     REGIONS                                 4
    default: IX     AQ$_ORDERS_QUEUETABLE_G                 0
    default: IX     AQ$_ORDERS_QUEUETABLE_H                 2
    default: IX     AQ$_ORDERS_QUEUETABLE_I                 2
    default: IX     AQ$_ORDERS_QUEUETABLE_L                 2
    default: IX     AQ$_ORDERS_QUEUETABLE_S                 4
    default: IX     AQ$_ORDERS_QUEUETABLE_T                 0
    default: IX     AQ$_STREAMS_QUEUE_TABLE_C               0
    default: IX     AQ$_STREAMS_QUEUE_TABLE_G               0
    default: IX     AQ$_STREAMS_QUEUE_TABLE_H               0
    default: IX     AQ$_STREAMS_QUEUE_TABLE_I               0
    default: IX     AQ$_STREAMS_QUEUE_TABLE_L               0
    default: IX     AQ$_STREAMS_QUEUE_TABLE_S               1
    default: IX     AQ$_STREAMS_QUEUE_TABLE_T               0
    default: IX     ORDERS_QUEUETABLE                       1
    default: IX     STREAMS_QUEUE_TABLE                     0
    default: IX     SYS_IOT_OVER_78100                      0
    default: IX     SYS_IOT_OVER_78129                      0
    default: OE     ACTION_TABLE                          132
    default: OE     CATEGORIES_TAB                         22
    default: OE     CUSTOMERS                             319
    default: OE     INVENTORIES                          1112
    default: OE     LINEITEM_TABLE                       2232
    default: OE     ORDERS                                105
    default: OE     ORDER_ITEMS                           665
    default: OE     PRODUCT_DESCRIPTIONS                 8640
    default: OE     PRODUCT_INFORMATION                   288
    default: OE     PRODUCT_REF_LIST_NESTEDTAB            288
    default: OE     PROMOTIONS                              2
    default: OE     PURCHASEORDER                         132
    default: OE     SUBCATEGORY_REF_LIST_NESTEDTAB         21
    default: OE     WAREHOUSES                              9
    default: PM     PRINT_MEDIA                             4
    default: PM     TEXTDOCS_NESTEDTAB                     12
    default: SH     CAL_MONTH_SALES_MV                     48
    default: SH     CHANNELS                                5
    default: SH     COSTS                                   0
    default: SH     COUNTRIES                              23
    default: SH     CUSTOMERS                           55500
    default: SH     DR$SUP_TEXT_IDX$B
    default: SH     DR$SUP_TEXT_IDX$C
    default: SH     DR$SUP_TEXT_IDX$I
    default: SH     DR$SUP_TEXT_IDX$K
    default: SH     DR$SUP_TEXT_IDX$N
    default: SH     DR$SUP_TEXT_IDX$Q
    default: SH     DR$SUP_TEXT_IDX$U
    default: SH     FWEEK_PSCAT_SALES_MV                11266
    default: SH     PRODUCTS                               72
    default: SH     PROMOTIONS                            503
    default: SH     SALES                              918843
    default: SH     SALES_TRANSACTIONS_EXT
    default: SH     SUPPLEMENTARY_DEMOGRAPHICS           4500
    default: SH     TIMES                                1826
    default: 
    default: 59 rows selected.
    default: 
    default: 
    default: Index cardinality (without  LOB indexes)
    default: 
    default: OWNER  INDEX_NAME                DISTINCT_KEYS   NUM_ROWS
    default: ------ ------------------------- ------------- ----------
    default: HR     COUNTRY_C_ID_PK                      25         25
    default: HR     DEPT_ID_PK                           27         27
    default: HR     DEPT_LOCATION_IX                      7         27
    default: HR     EMP_DEPARTMENT_IX                    11        106
    default: HR     EMP_EMAIL_UK                        107        107
    default: HR     EMP_EMP_ID_PK                       107        107
    default: HR     EMP_JOB_IX                           19        107
    default: HR     EMP_MANAGER_IX                       18        106
    default: HR     EMP_NAME_IX                         107        107
    default: HR     JHIST_DEPARTMENT_IX                   6         10
    default: HR     JHIST_EMPLOYEE_IX                     7         10
    default: HR     JHIST_EMP_ID_ST_DATE_PK              10         10
    default: HR     JHIST_JOB_IX                          8         10
    default: HR     JOB_ID_PK                            19         19
    default: HR     LOC_CITY_IX                          23         23
    default: HR     LOC_COUNTRY_IX                       14         23
    default: HR     LOC_ID_PK                            23         23
    default: HR     LOC_STATE_PROVINCE_IX                17         17
    default: HR     REG_ID_PK                             4          4
    default: IX     AQ$_STREAMS_QUEUE_TABLE_Y             0          0
    default: OE     ACTION_TABLE_MEMBERS                132        132
    default: OE     CUSTOMERS_PK                        319        319
    default: OE     CUST_ACCOUNT_MANAGER_IX               4        319
    default: OE     CUST_EMAIL_IX                       319        319
    default: OE     CUST_LNAME_IX                       176        319
    default: OE     CUST_UPPER_NAME_IX                  319        319
    default: OE     INVENTORY_IX                       1112       1112
    default: OE     INV_PRODUCT_IX                      208       1112
    default: OE     ITEM_ORDER_IX                       105        665
    default: OE     ITEM_PRODUCT_IX                     185        665
    default: OE     LINEITEM_TABLE_MEMBERS              132        132
    default: OE     ORDER_ITEMS_PK                      665        665
    default: OE     ORDER_ITEMS_UK                      665        665
    default: OE     ORDER_PK                            105        105
    default: OE     ORD_CUSTOMER_IX                      47        105
    default: OE     ORD_ORDER_DATE_IX                   105        105
    default: OE     ORD_SALES_REP_IX                      9         70
    default: OE     PRD_DESC_PK                        8640       8640
    default: OE     PRODUCT_INFORMATION_PK              288        288
    default: OE     PROD_NAME_IX                       3727       8640
    default: OE     PROD_SUPPLIER_IX                     62        288
    default: OE     PROMO_ID_PK                           2          2
    default: OE     WAREHOUSES_PK                         9          9
    default: OE     WHS_LOCATION_IX                       9          9
    default: PM     PRINTMEDIA_PK                         4          4
    default: SH     CHANNELS_PK                           5          5
    default: SH     COSTS_PROD_BIX                        0          0
    default: SH     COSTS_TIME_BIX                        0          0
    default: SH     COUNTRIES_PK                         23         23
    default: SH     CUSTOMERS_GENDER_BIX                  2          5
    default: SH     CUSTOMERS_MARITAL_BIX                11         18
    default: SH     CUSTOMERS_PK                      55500      55500
    default: SH     CUSTOMERS_YOB_BIX                    75         75
    default: SH     DR$SUP_TEXT_IDX$KD                    0          0
    default: SH     DR$SUP_TEXT_IDX$KR                    0          0
    default: SH     DR$SUP_TEXT_IDX$X                     0          0
    default: SH     FW_PSC_S_MV_CHAN_BIX                  4          4
    default: SH     FW_PSC_S_MV_PROMO_BIX                 4          4
    default: SH     FW_PSC_S_MV_SUBCAT_BIX               21         21
    default: SH     FW_PSC_S_MV_WD_BIX                  210        210
    default: SH     PRODUCTS_PK                          72         72
    default: SH     PRODUCTS_PROD_CAT_IX                  5         72
    default: SH     PRODUCTS_PROD_STATUS_BIX              1          1
    default: SH     PRODUCTS_PROD_SUBCAT_IX              21         72
    default: SH     PROMO_PK                            503        503
    default: SH     SALES_CHANNEL_BIX                     4         92
    default: SH     SALES_CUST_BIX                     7059      35808
    default: SH     SALES_PROD_BIX                       72       1074
    default: SH     SALES_PROMO_BIX                       4         54
    default: SH     SALES_TIME_BIX                     1460       1460
    default: SH     SUP_TEXT_IDX
    default: SH     TIMES_PK                           1826       1826
    default: 
    default: 72 rows selected.
    default: 
    default: SQL> Disconnected from Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
    default: Version 23.2.0.0.0
honglin@honglin-mac vagrant-oracle-database-23c-free % 

Referece

参考:

Oracle Database 23c Freeの簡易セットアップ

vagrant-oracle-database-23c-free

Have a good work&life! 2023/03 via LinHong


Similar Posts

Comments