on 02-16-2013 12:01 PM
Hi All,
I was not able to load the data in to the respective table which i have created. I do get an error as: "Cannot open control file"
Can any one let me know how to resolve this issue and load the data successfully in to the respective tables?
Sanjay
Hi Sanjay,
Could probably be that you don't have read access/permission to your .ctl file.
If you have the linux root user (if not contact your system administrator) handy, you could try giving read-write access to your linux folder using the command:
chmod -R a=rwx <folder>
where <folder> is the path to your linux folder where .ctl file lies OR just google to find out how best to provide linux permissions. Remember, you will also need write permissions to create an error log file.
If giving the above access still doesn't help, do you mind copy pasting the entire error message here?
Thanks,
Anooj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sanjay,
If you are using a GUI give full permission to the folder and/file and try again. If you know Unix - try executing chmod 777 <folder name> at unix level and then it should work.
Hope this helps.
Rama
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.