|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions This is extract from Oracle10g Advanced Replication Book. How Materialized Views Work with Object Types and CollectionsOracle object types are user-defined datatypes that make it possible to model complex Thhere are 3 different ways :-1) SELECT name, value FROM v$parameter WHERE name = 'spfile'; //This query will return NULL if you are using PFILE2) SHOW PARAMETER spfile // This query will returns Latest Answer : Go to OEM => Databases => ... => Instance => Configuration, in "Database and Instance Information" section, the last row shows spfile ... These are a few of the advantages of using DBCA:You can use its wizards to guide you through a selection of options providing an easy means of creating and tailoring your database. It allows you to provide Latest Answer : The Database Configuration Assistant guides you through the process of creating a new database, changing the configuration of an existing database, or deleting a database. Many of the database creation tasks you would normally perform manually are performed ... What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly? Read Answers (1) | Asked by : Manoj Kumar Latest Answer : Export is one of taking backup. In export backup you can specify many parameters in par file or at command line. One of the parameter is statistics=y or n. If you specify y it is going to export statistics generated in the database placed ... While Installing Oracle9i/10g at unix (RedHat) environment , which parameter needs to be set at OS level, to login as a sysdba in Oracle for the first time? Latest Answer : .bash_profile has to set at OS level before connecting to oracle database. ... You have a database of 2GB. Can you convert the database to 1GB. Which compression parameter will you use? Latest Answer : COMPRESSION =(METADATA_ONLY | NONE) - This parameter applies from Oracle 10.2. It specifies whether to compress metadata before writing to the dump file set. Compression reduces the amount of disk space consumed by dump files.To convert from 2 GB to 1 ... DBMS_meta_data. This parameter is very usefull. What you infer from this parameter. What info you will find in that. explain in detail. Latest Answer : To find the structure of a external table we used this package.syntax is below:SELECT DBMS_METADATA.GET_DDL ('TABLE','')||';' FROM DUAL ... My database size is 100GB. I am using compress parameter. Will my database size reduce, remain same, Increase. What will Happen. exp userid=system/manager file=expfile.dmp log=expfile.log full=Y compress=Y buffer=1000000If i do't mention compress & buffer parameter , then this query will run/not. Latest Answer : Yes, exactly it will run perfectly because compress and buffer both are optional. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
