Skip to content

Instantly share code, notes, and snippets.

@shadabshaukat

shadabshaukat/table.sql

Created March 10, 2021 23:10
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save shadabshaukat/66af983d9cc973020161f98b055df1b8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save shadabshaukat/66af983d9cc973020161f98b055df1b8 to your computer and use it in GitHub Desktop.
Download ZIP
Table
Raw
table.sql
create table big_table
as
select rownum id,
OWNER, OBJECT_NAME, SUBOBJECT_NAME,
OBJECT_ID, DATA_OBJECT_ID,
OBJECT_TYPE, CREATED, LAST_DDL_TIME,
TIMESTAMP, STATUS, TEMPORARY,
GENERATED, SECONDARY
from all_objects a
where 1=0
/
alter table big_table nologging;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment