The default value is 0.
You were able to create a table befause of 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 ...
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.
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.
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
/tmp/client/runInstaller -silent -responseFile /tmp/...