http://www.geekinterview.com/talk/ en Sat, 21 Nov 2009 14:53:16 GMT vBulletin 60 http://www.geekinterview.com/talk/images/misc/rss.jpg http://www.geekinterview.com/talk/ http://www.geekinterview.com/talk/16568-possible-use-sql-loader-type-text.html Fri, 20 Nov 2009 05:20:08 GMT Hi, I have a text file which has the following data. 1§00§EMPLOYEE§ 1§50§2009-09-08 10:53:14.0§23232426§§ 1§50§2009-09-08... Hi,

I have a text file which has the following data.

1§00§EMPLOYEE§
1§50§2009-09-08 10:53:14.0§23232426§§
1§50§2009-09-08 10:53:14.0§23232427§§
1§99§2§

1§00§EMPLOYEEINFO§
1§50§2009-09-08 10:53:14.0§Rama§§
1§50§2009-09-08 10:53:14.0§George§§
1§99§2§

Here

EMPLOYEE and EMPLOYEEINFO are 2 data from different tables which I want to bulk upload into my database tables.

EMPLOYEE has 2 rows of data. The final line states the count of data. Then starts the data for the EMPLOYEEINFO . The final line states the count of data for EMPLOYEEINFO table.

Now, I want to use SQL Loader to bulk update the data from this text file into two tables in my data base EMPLOYEE and EMPLOYEEINFO.

Can I use SQL Loader for this type of data file? If so, how can I read the data? Please help. ]]> Oracle sowmyasridhar http://www.geekinterview.com/talk/16568-possible-use-sql-loader-type-text.html http://www.geekinterview.com/talk/16531-data-files-problem.html Sat, 14 Nov 2009 10:00:26 GMT Manually i was dropped use,tablespace,datafiles but in dba_data_files ,the datafile name still exist,how to remove that datafile from... Manually i was dropped use,tablespace,datafiles but in
dba_data_files ,the datafile name still exist,how to remove that datafile from dba_data_files table ]]> Oracle susarlasireesha http://www.geekinterview.com/talk/16531-data-files-problem.html http://www.geekinterview.com/talk/16515-remote-database-sysdate.html Thu, 12 Nov 2009 07:01:19 GMT How to get remote database sysdate with out using remote database functions/procedure ?? How to get remote database sysdate with out using remote database functions/procedure ?? ]]> Oracle susarlasireesha http://www.geekinterview.com/talk/16515-remote-database-sysdate.html http://www.geekinterview.com/talk/16480-oracle-user-privileges.html Sun, 08 Nov 2009 16:06:19 GMT which dictionary view will show all the privileges assigned to an oracle user? which dictionary view will show all the privileges assigned to an oracle user? ]]> Oracle SDBA_ http://www.geekinterview.com/talk/16480-oracle-user-privileges.html http://www.geekinterview.com/talk/16417-restore-control-file-using-rman-backup.html Wed, 28 Oct 2009 11:45:04 GMT How to restore control file by using RMAN backup? Error: RMAN:06563: Control file or spfile must be restored from autobackup. I received the... How to restore control file by using RMAN backup?

Error:
RMAN:06563: Control file or spfile must be restored from autobackup.

I received the above error and help me to recover this problem ]]> Oracle tykarthick http://www.geekinterview.com/talk/16417-restore-control-file-using-rman-backup.html http://www.geekinterview.com/talk/16411-oracle-rman-script.html Tue, 27 Oct 2009 11:58:50 GMT 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... 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? ]]> Oracle jdbaig1 http://www.geekinterview.com/talk/16411-oracle-rman-script.html http://www.geekinterview.com/talk/16404-how-will-u-create-database-server.html Mon, 26 Oct 2009 13:11:45 GMT how will u create database in server without sql agent... how will u create database in server without sql agent... ]]> Oracle adinesh.dba http://www.geekinterview.com/talk/16404-how-will-u-create-database-server.html