Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to join these two tables

CatinredbootsOct 9 2018 — edited Oct 10 2018

Hello,

Can sebody hold me on joining these two tables?

desc dba_tablespaces

Name                                                                                                              Null?    Type

----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------

TABLESPACE_NAME                                                                                                   NOT NULL VARCHAR2(30)

BLOCK_SIZE                                                                                                        NOT NULL NUMBER

INITIAL_EXTENT                                                                                                             NUMBER

NEXT_EXTENT                                                                                                                NUMBER

MIN_EXTENTS                                                                                                       NOT NULL NUMBER

MAX_EXTENTS                                                                                                                NUMBER

MAX_SIZE                                                                                                                   NUMBER

PCT_INCREASE                                                                                                               NUMBER

MIN_EXTLEN                                                                                                                 NUMBER

STATUS                                                                                                                     VARCHAR2(9)

CONTENTS                                                                                                                   VARCHAR2(9)

LOGGING                                                                                                                    VARCHAR2(9)

FORCE_LOGGING                                                                                                              VARCHAR2(3)

EXTENT_MANAGEMENT                                                                                                          VARCHAR2(10)

ALLOCATION_TYPE                                                                                                            VARCHAR2(9)

PLUGGED_IN                                                                                                                 VARCHAR2(3)

SEGMENT_SPACE_MANAGEMENT                                                                                                   VARCHAR2(6)

DEF_TAB_COMPRESSION                                                                                                        VARCHAR2(8)

RETENTION                                                                                                                  VARCHAR2(11)

BIGFILE                                                                                                                    VARCHAR2(3)

PREDICATE_EVALUATION                                                                                                       VARCHAR2(7)

ENCRYPTED                                                                                                                  VARCHAR2(3)

COMPRESS_FOR                                                                                                               VARCHAR2(30)

DEF_INMEMORY                                                                                                               VARCHAR2(8)

DEF_INMEMORY_PRIORITY                                                                                                      VARCHAR2(8)

DEF_INMEMORY_DISTRIBUTE                                                                                                    VARCHAR2(15)

DEF_INMEMORY_COMPRESSION                                                                                                   VARCHAR2(17)

DEF_INMEMORY_DUPLICATE                                                                                                     VARCHAR2(13)

desc v$encrypted_tablespaces

Name                                                                                                              Null?    Type

----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------

TS#                                                                                                                        NUMBER

ENCRYPTIONALG                                                                                                              VARCHAR2(7)

ENCRYPTEDTS                                                                                                                VARCHAR2(3)

ENCRYTPEDKEY                                                                                                               RAW(32)

MASTERKEYID                                                                                                                RAW(16)

BLOCKS_ENCRYPTED                                                                                                           NUMBER

BLOCKS_DECRYPTED                                                                                                           NUMBER

CON_ID                  

I need to display TABLESPACE_NAME, ENCRYTPEDKEY, MASTERKEYID, ENCRYPTIONALG, ENCRYPTED

Comments
Post Details
Added on Oct 9 2018
4 comments
548 views