3.4.1 List Datasets

To display information about an Exascale dataset, use the ESCLI lsdataset command.

  • To display a simple list of all datasets in all vaults, use the lsdataset command with no arguments or options. For example:

    @> lsdataset
  • To display detailed information about a specific dataset, use the lsdataset command with the --detail option and specify the dataset identifier.

    Each system-defined dataset has a unique composite identifier, which contains unique identifiers for the associated entities. The dataset identifier has one of the following formats:

    • @Vault-name: Identifies the vault-level dataset for a specific named vault.

    • @Vault-name:GI-cluster-ID: Identifies the dataset for a specific Oracle Grid Infrastructure (GI) cluster, which consumes storage space in the specified vault.

    • @Vault-name:GI-cluster-ID:CDB-ID: Identifies the dataset for a specific Oracle multitenant container database (CDB) that belongs to the specified GI cluster.

    • @Vault-name:GI-cluster-ID:CDB-ID:PDB-ID: Identifies the dataset for an Oracle pluggable database (PDB) that is associated with the specified CDB, GI cluster, and vault.

    For example, the following command displays detailed information about a specific PDB dataset.

    @> lsdataset --details @MYDATA:a5b4997a027d6f91ffd9729702ff6ec5:1427076301:2164757665
  • To display information about the files in a specific dataset, use the lsdataset command with the --files option and specify the dataset identifier.

    For example, the following command lists the files that belong to the specified GI-level dataset.

    @> lsdataset --files @MYDATA:a5b4997a027d6f91ffd9729702ff6ec5

    If you add the --recursive option, then the command output also includes the files in all of the descendant datasets.

    For example, the following command shows the files belonging to the specified GI cluster and all of the associated CDB and PDB datasets.

    @> lsdataset --files --recursive @MYDATA:a5b4997a027d6f91ffd9729702ff6ec5
  • When specifying a dataset identifier, the asterisk (*) can be used for wildcard searches.

    For example, the following command lists all CDB datasets associated with the specified GI cluster and vault.

    @> lsdataset @MYDATA:a5b4997a027d6f91ffd9729702ff6ec5:*

Using other command options available with the lsdataset command, you can also:

  • Filter the output according to your specified conditions.
  • Sort the output using specific attributes.
  • Choose the dataset attributes that are displayed.