ASM Queries

 SET LINESIZE  550

SET PAGESIZE  9999

SET VERIFY    off  

 

COLUMN full_alias_path        FORMAT a63                  HEAD 'File Name'

COLUMN system_created         FORMAT a8                   HEAD 'System|Created?'

COLUMN type                   FORMAT a18                  HEAD 'File Type'

COLUMN redundancy             FORMAT a12                  HEAD 'Redundancy'

COLUMN striped                FORMAT a8                   HEAD 'Striped'

COLUMN creation_date          FORMAT a20                  HEAD 'Creation Date'

COLUMN disk_group_name        noprint

SELECT

    CONCAT('+' || disk_group_name, SYS_CONNECT_BY_PATH(alias_name, '/')) full_alias_path

  ,  space/(1024*1024*1024*2) "InGB"

  , NVL(LPAD(type, 18), 'DATAC1')  type

  , creation_date

  , disk_group_name

  , LPAD(system_created, 4) system_created

FROM

    ( SELECT

          g.name               disk_group_name

        , a.parent_index       pindex

        , a.name               alias_name

        , a.reference_index    rindex

        , a.system_created     system_created

        , f.bytes              bytes

        , f.space              space

        , f.type               type

        , TO_CHAR(f.creation_date, 'DD-MON-YYYY HH24:MI:SS')  creation_date

      FROM

          v$asm_file f RIGHT OUTER JOIN v$asm_alias     a USING (group_number, file_number)

                                   JOIN v$asm_diskgroup g USING (group_number)

    )

WHERE type IS NOT NULL

and  space/(1024*1024*1024*2) >500

START WITH (MOD(pindex, POWER(2, 24))) = 0

    CONNECT BY PRIOR rindex = pindex

order by space/(1024*1024*1024*2) desc 

/

Migration

 Migration

select  count(1),segment_type from dba_segments where tablespace_name='LOB_NEW' group by segment_type;

SELECT TABLE_OWNER,TABLE_NAME,COLUMN_NAME,LOB_NAME,PARTITION_NAME,LOB_PARTITION_NAME,SECUREFILE,TABLESPACE_NAME

FROM DBA_LOB_PARTITIONS 

WHERE TABLE_OWNER = 'CCUSER' 

AND TABLESPACE_NAME = 'LOB'

AND TABLE_NAME = 'CC_MESSAGE';

select 'ALTER TABLE '||TABLE_OWNER||'.'||TABLE_NAME||' MOVE PARTITION '||partition_name||' LOB ('||column_name||') STORE AS BASICFILE (TABLESPACE LOB_NEW) parallel 32;' from 

DBA_LOB_PARTITIONS 

WHERE TABLE_OWNER = 'CCUSER' 

AND TABLESPACE_NAME = 'LOB'

AND TABLE_NAME = 'CC_MESSAGE';

select 'ALTER TABLE ' || OWNER || '.' || TABLE_NAME || ' MOVE TABLESPACE PROD_DATA;' from DBA_TABLES WHERE OWNER ='PROD';

select 'ALTER INDEX ' || OWNER || '.'|| index_name ||' rebuild tablespace INDX_TB online;' from dba_indexes where owner='PROD';

can you try this :

create tablespace lepdata 
datafile '+p1rac1d4_oradata' size 20g
logging
online
permanent
blocksize 8192
extent management local autoallocate
default nocompress
segment space management auto;

Course URL: - https://learn.microsoft.com/en-us/training/courses/AZ-104T00?WT.mc_id=ilt_partner_webpage_wwl&ocid=4428290&DCS=DEPR2340032#study-guide 

Achievement Code URL: - https://learn.microsoft.com/en-us/users/me/achievements?redeem=RDG8DZ&WT.mc_id=ilt_partner_webpage_wwl&ocid=4428290&DCS=DEPR2340032

https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fforms.office.com%2Fr%2FNx5dy3JiLW&data=05%7C01%7CRM00759529%40TechMahindra.com%7C465303814e924bfb158708db1b1939f9%7Cedf442f5b9944c86a131b42b03a16c95%7C0%7C0%7C638133567383492233%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=C%2FAc9WeKaVKB0QRGjFuk0x%2B6WZQRRgrrrjtKsJJtwkY%3D&reserved=0