Hot answers tagged

2

The default value is 0. You were able to create a table befause of deferred segment creation. CREATE TABLE deferred_segment_creation Use this clause to determine when the database should create the segment(s) for this table: SEGMENT CREATION DEFERRED: This clause defers creation of the table segment — as well as segments for any LOB ...


2

General process to create an AQ create an Object type create a Queue Table create the Queue The queue message (1) is stored in a queue table (2). You can view a list of queue tables by looking at ALL_QUEUE_TABLES.


1

all the three options would work, but would prefer to use first or the second one in production environment to avoid queries failing post activity due to not enough temp tablespace. Would recommend identifying the usage history pattern using queries similar to the one defined in this blog and then use that for your keep size. https://zukus.blogspot.com/2016/...


1

That will not work, that is not how you execute commands as an other user. + Only root can run passwd username, not even oracle user can run passwd oracle. sudo su oracle; echo Nbst@AWS01 | passwd oracle --stdin export ORACLE_BASE=/opt/app/oracle export ORACLE_HOME=/opt/app/oracle/product/12.2.0/client_1 /tmp/client/runInstaller -silent -responseFile /tmp/...


Only top voted, non community-wiki answers of a minimum length are eligible