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 is db_recovery_file_dest in oracle? When do you need to set this value?

661


How many segment are present in Oracle Manufacturing

1819


How would you determine what sessions are connected and what resources they are waiting for?

1618


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

1642


Explain the payment term in ar. : oracle accounts receivable

625






which one is currently in used software cmpanies.

1665


Where in the Oracle directory tree structure are audit traces placed?

2133


types of receipts and detail desription about recipts and tables effected by receipts?

1643


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

647


what are basic modules required to implement oracle application in any oraganisation?

1716


where the dff data will be stored

1810


TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

2845


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

1780


What is auto invoicing? Explain : oracle accounts receivable

620


How do you create a credit note against an invoice? : oracle accounts receivable

659