-
Tablespace Management
What are the ways tablespaces can be managed and how do they differ?
Affrayam
- Mar 8th, 2013
The difference between LMTS & DMTS is if the extent management is local(LMTS) the information about free extents and free blocks will be maintained in DATAFILE HEADER it self AND if the extent managem...
ashdba
- Sep 5th, 2010
Tablespace can be managed by specifying Extent management local or Extent management dictionary, segment space management auto or manually by using the key words pctfree, pctused, pctincrease during tablepsace creation.
-
Is (DDL) Data Manipulation Language statements Autocommit?
No. Only the DDL(Data Definition Language )statements like create,alter,drop,truncate are auto commit.But the DML statements are should be saved by giving the commit statement after execute the query
-
I have got the following error when importing few of my package bodies and triggers. ORA-01653: unable to extend table SYS.IDL_UB1$ by 13 in tablespace SYSTEM The tablespace SYSTEM had enough space at the time of import. Later when I tried to create theses objects seperately through a script, they were successfully created. It is important to note that not all package bodies and triggers failed. If you have any idea regarding this error, please let me know the problem and solution, if possible.
daid_k
- Aug 21st, 2007
Drop the table? SYS.IDL_UB1$? for that location then you can Import witout error.
-
How can we execute dynamic SQL From PL/SQL block?
rajakumar_na
- Nov 14th, 2007
here is the example for DBMS_SQL:CREATE OR REPLACE PROCEDURE delete_all_rows(p_tab_name IN VARCHAR2, p_rows_del OUT NUMBER)IScursor_name INTEGER;BEGINcursor_name := DBMS_SQL.OPEN_CURSOR;DBMS_SQL.PARSE...
-
Can we create sequence to a View??
suganya
- Nov 30th, 2011
No....because sequence is used for creating the integer sequence values only at the time of table creation...
but view is a subset of data for the base table.....so cant create the sequence for the viewshamkohli
- Jun 17th, 2008
Sequence is used to generate numbers which can be stored in tables. View does not have data of its own and is generally used to query data. So sequence can not be created to a view.
-
InitSID.ora is a parameter file.But which Parameter file SPfile or Pfile?
MAHE
- Sep 16th, 2011
It is a Pfile
hkrishna
- Jul 28th, 2008
Hi Friend,Here is simple defination initSID.ora will tell you SID is the database name where you are going to creating a new database.when you create database it'll take you as pfile and spfile is the system parameter file which you can convert if you required use in database.
-
What is one time procedure
javedans
- Jul 8th, 2009
One time procedure, Its actually not a procedure but its called as one time procedure, Why because this used to initialize variable, calling function or procedure once the scope of package for user se...
Thulasidas
- Dec 5th, 2006
And the primary purpose of one time procedure is for one time initialisation of package variables
-
Import MS-Access Tables
How to import tables from MS-Access to Oracle?
michaelsmith035
- Jul 30th, 2011
If you successfully exported the data to text file , then you are very close! In the export option of Microsoft Access, you shall see an option like "Export to ODBC database". If you click that, you...
anand_study
- Sep 25th, 2008
This might help someone if need to get table into Oracle from MS Access table.Option-1 - Use MS Access (2003) Export 1. Oracle Client and Oracle ODBC driver should be installed on your PC.2. In O...
-
How to insert more then one record from one table to another table in oracle,in some specific colums
ROHIT_4444
- Mar 27th, 2007
SUPOOSE WE HAVE TWO TABLE R_ITEM_MASTER & ITEM_MASTERIN R_ITEM MASTER THERE ARE ITM_ITEM_CODE,ITM_DESC,ITM_UM,ITM_CURR_COST_RATE FOUR FIELDS BUT WE WANT TO INSERT RECORDS ONLY IN TWO COLUMSINSERT INTO R_ITEM_MASTER (ITM_ITM_CODE,ITM_UM) SELECT ITM_ITEM_CODE,ITM_UM FROM ITEM_MASTER
-
-
Difference between Execute, Execute Query, Execute Update and Execute Batch.
do
- Aug 1st, 2011
Does it return only integer?
-
What is the difference between ROUND and TRUNC function in SQL? ">
What is the difference between ROUND and TRUNC function in SQL?
Both TRUC and ROUND are single value functions.
TRUNC:
TRUNC function truncates that is in other words cuts off to the digits specified.
The general syntax of TRUNC function is:
TRUNC(number, precision);
For instance:
Suppose the value of salary in employee table for ename= ’Exforsys’ is 55.666
Then
Select... -
What are the commands that come in the category of DML in SQL?
DML refers to Data Manipulation Statements. That is used for accessing and modifying values or data present in the database.
The commands that come in the category of DML in SQL
INSERT
SELECT
DELETE
UPDATE
INSERT:
This command is used to insert rows into the table.
SYNTAX:
INSERT INTO tablename...kishore.giri
- Dec 10th, 2007
The DML is for Data Manipulation Langugae i.e. those commands comes into picture that modifies datavalues in the database.The DML commands are INSERT,UPDATE,DELETE,MERGE.Some body answers that&n...
-
-
How many types of triggers used in d2k report What r they?
sateeshkonthala
- Nov 21st, 2011
There are eight report triggers. Of these there are five global triggers called the Report Triggers. They are fired in the following order : * Before Parameter Form * After Parameter Form * Before R...
selvaspak
- Dec 31st, 2010
Total 5 Types of Trigger1. Before Parameter Trigger2. After parameter Trigger3. Before Report Trigger4. Between Pages Trigger5. After Report Triggerthe Action are given below1. Before Parameter T...
-
What are the differences of view and materialised view
gautthamm
- Dec 31st, 2008
After update of the table, the view automatically gets synchronized where as the Materialised view needs an explicit refresh (either Manual or by Oracle) for synchronisation.Another diff is that the r...
Jirange
- Oct 15th, 2008
View is a replica of table.Materialized? view is remote table on local database.
-
-
What is the difference between cold backup and hot backup
Read Best Answer
Editorial / Best Answer
ttparavindh- Member Since Jun-2007 | Jun 19th, 2007
Cold Backup- We can take the Backup while DB(eg. Oracle) is down.
Hot Backup-We can take the Backup while DB(eg. Oracle) is running.
Cold backup is a physical backup. During a cold backup the database is closed and not available to users. All files of the database are copied (image copy). The datafiles do not change during the copy so the database is in sync upon restore.
Used when:Service level allows for some down time for backup
Hot backup is a physical backup. In a hot backup the database remains open and available to users. All files of the database are copied (image copy). There may be changes to the database as the copy is made and so all log files of changes being made during the backup must be saved too. Upon a restore, the changes in the log files are reapplied to bring the database in sync. Used when:A full backup of a database is needed
Service level allows no down time for the backupkrishnaprasad.sola
- Feb 9th, 2009
Cold Backup is possible only when the database is down means it is not available to users to access. Disadvantage is we effort downtime. Here we need to take backup of datafiles, control files, redo...
srk.srikanth
- Feb 8th, 2009
Cold Backup: Need to back up Database Files, Control Files, Online Redo Log files.Hot Backup: Need to back up Database Files, ControlFiles, Offline Redo Log files (archive files).
-
How to write RESERVE WORD as table column?For example if you want to write Number as table column name How do you write?
vamsikatragadda
- Mar 9th, 2008
You Can do it Simply but keeping the table name in quotes Here it goes like thisCreate table "table" as select * from table_name;and your problem is solvedenjoy
-
Create a report for the HR department that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label.
Oracle Basics Interview Questions
Read Best Answer
Ans