By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,245 Members | 1,324 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,245 IT Pros & Developers. It's quick & easy.

external table creation

P: 1
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
Share this question for a faster answer!
Share on Google+

Post your reply

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