Commands:

Create Oracle user tpcds

SQL> create user tpcds with password 'ffgfh';

Generate load data

• mkdir /tmp/tpc
• dsdgen -scale 1 -dir /tmp/tpc

Load data

• su - oracle
• mkdir tpcds

Create control file:

• vi web_site.ctl

load data
infile '/tmp/tpc/web_site.dat'
into table web_site
fields terminated by '|'
( WEB_SITE_SK, WEB_SITE_ID, WEB_REC_START_DATE date "YYYY-MM-DD", WEB_REC_END_DATE date "YYYY-MM-DD", WEB_NAME, WE
B_OPEN_DATE_SK, WEB_CLOSE_DATE_SK, WEB_CLASS, WEB_MANAGER, WEB_MKT_ID, WEB_MKT_CLASS, WEB_MKT_DESC, WEB_MARKET_MAN
AGER, WEB_COMPANY_ID, WEB_COMPANY_NAME, WEB_STREET_NUMBER, WEB_STREET_NAME, WEB_STREET_TYPE, WEB_SUITE_NUMBER, WEB
_CITY, WEB_COUNTY, WEB_STATE, WEB_ZIP, WEB_COUNTRY, WEB_GMT_OFFSET, WEB_TAX_PERCENTAGE )

Import the data using Oracle Loader

• sqlldr tpcds/tpcds_1234 control=web_site.ctl

http://www.tpc.org/tpcds/default.asp
http://agni.csa.iisc.ernet.in/CASL/tpcds
http://www.orafaq.com/wiki/SQL*Loader_FAQ