469,342 Members | 5,667 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,342 developers. It's quick & easy.

external table creation

HI Guys,

Could you please help me how to create external table with only one filed(number data type) in oracle

I used the below code but it was not loading the data.
Expand|Select|Wrap|Line Numbers
  1. CREATE TABLE SOLNGLOBAL_ORIG_DATA_656356 (Account_NUMBER     NUMBER ) ORGANIZATION external (  DEFAULT DIRECTORY SWA_ED20307_OTHERPREP ACCESS PARAMETERS  (RECORDS DELIMITED BY NEWLINE ) LOCATION ( 'swa_privacy_delete_request_20200402_S6.txt' )  ) REJECT LIMIT UNLIMITED 
Could you please help me guys.

Thanks,
Sudhakar Boyalla
Apr 3 '20 #1
0 2038

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Erohsik | last post: by
4 posts views Thread by Chris via AccessMonster.com | last post: by
reply views Thread by Sameers (theAngrycodeR) via .NET 247 | last post: by
1 post views Thread by monishkar | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by haryvincent176 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.