How do you add a data file to a tablespace?

Answer Posted / shams tabrez

alter tablesapce <tablespace_name> add
datafile '/data/file/lcoation_01.dbf' size 10m autoextend
on;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1864


TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3199


What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

1817


Why more redos are generated when the oracle database is in begin backup mode?

881


What are different types of receipt reversals ? Explain them : oracle accounts receivable

977


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2257


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1027


What is Restricted Mode of Instance Startup in Oracle?

923


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4181


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2053


can u give guidance abt packages of plsql

1864


hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

1993


What is Tax Categories?

1834


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1890


8. Supporting AP, AR and GL?

2063