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
How would you best determine why your MVIEW couldn't FAST REFRESH?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how can you implement fine-grained auditing?
what are the differences of where and if in SAS?
internal architecture
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Explain materialized views and how they are used.
how can you enable flashback feature?
What are the different ways you can create databases in sql server? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what do you understand by fine-grained auditing?
what functionality does oracle provide to secure sensitive information?
who owns the operating system files created by the utl_file package?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA