CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva
CTS,
2 7424I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........
1 12648I 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
4339Oracle 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.
2559currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
2429Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
2626Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
2187hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?
1 4167Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
2098How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
EDS,
2083Post New DB Administration Questions
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
suppose you want to audit specific activities on sensitive data. How can you achieve that?
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
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
how can you find out if a table can be redefined?
What purpose does the model database server? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is dbcc? : sql server DBA
how can you implement fine-grained auditing?
What is fill factor? : sql server DBA
What is a correlated sub-query? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA