What is the difference between the SQL Loader and IMPORT
utilities?
- 3 Answers
- 19175 Views
- I also Faced
- E-Mail Answers
Answer Posted / kunal sain
Sql loader can import data from any flat files
where as import command import data from exported file.
| Is This Answer Correct ? | 23 Yes | 1 No |
Post New Answer View All Answers
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Explain materialized views and how they are used.
What is a system database and what is a user database? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What would you do with an "in-doubt" distributed transaction?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
what is ora 24313?what is the procedure to exclude that error?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Why does Oracle not permit the use of PCTUSED with indexes?
how can you enable flashback feature?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
