Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rohit bhosale
Create Database [database_name] On Primary
(
Name='abc', Filename='path_of_mdf_file'
)
log on
(
Name='abc_log', Filename='path_of_ldf_file'
)
Eg:
Create database emp on primary
(
name='emp1', filename='d:\sql\emp.mdf'
)
log on
(
name='emp1_log', filename='d:\sql\emp_log.ldf'
)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is a user-defined lock?
What the different types of replication and why are they used? : sql server DBA
who owns the operating system files created by the utl_file package?
What are statistics, under what circumstances they go out of date, how do you update them?
What is replication? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What are the recovery models for a database? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
what functionality does oracle provide to secure sensitive information?
what is the use of recording information about current session?
what do you understand by flashback feature of oracle?
what is asm?
What is dcl? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
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
