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. ...
three types,they are object-based logic models,record-based logic models,and physical models.
Latest Answer : There are no standards in this area. Authors and theorists make it up as they go. The entity-relationship model (ER) has hundreds of derivitives (bachman, chen, ibm, IDEF1x etc.). the most popular of the OO models is Unified Modeling Language (UML). ...
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
How can a user access all the Data Dictionary Views - Say If Scott user needs to be given the privilege of viewing all the Data Dictionary Views, What needs to be done ?
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