How can you prevent the users logging in through tools like TOAD or SQL Navigator or PLSQL Developer..?
Connect as sydba Write a LOGON trigger like this CREATE OR REPLACE TRIGGER RESTRICT_TOOL AFTER LOGON ON DATABASEDECLARE L_TOOL V$SESSION.PROGRAM%TYPE;BEGIN SELECT
Latest Answer : using SQLLOADER you can migrate data from non oracle database to oracle database. ...
I have Employee information in MS-Excel format , now i want to convert in to Oracle database. is it possible to do this task, can any one please help me
1. This question involves different aspects of an operational database compared to a data warehouse.a) Since there are differences between a data warehouse and an operational database, how does this effect the people requirements of each. What differences are there in terms of how many people need to be assigned to the data warehouse team and how many people need to be assigned to the operational database team? Also, what type of skills are needed for the people assigned to the data warehouse team
I have a production 24/7 database and i am looking at refreshing the database, how is it possible ? Mind you ! Its a production 24/7 database nad hence cannot be shutdown ?
I have student table with fields name,marks1,marks2,marks3 fileds. i want the output as the student details and thier totals and their rank in class, i.e calculated at runtime.please send me the query in sql server or oracle
How to maintain Big database During END of the Year????Example:My DataBase is Store and it has 40 tables..so after new year i want new transcation in new database.but Whats happen with my pandding data which is in old year ???this is My query
How to fetch old data with new database? suppose current inventory store in current database but after new year starting i want to store new year data in new database so howto fetch old data
Will the ‘View’ get refreshed immediately when you update a database table. If it doesn’t get refreshed immediately, what method you use to refresh it ?
I have my DB2 database on mainframes and I am trying to replicate the same database on Windows server. I have loaded the table definitions to the Windows servers but looking for a way to export data from Mainframe DB2 tables to Windows server tables (Table definitions in both servers are same).I am looking for an easy and efficient way which can take care of nulls, strings, delimiters etc while exporting.Any help!
