Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Copy of Database
- Thread starter TidyTrax
- Start date
SantaMufasa
Technical User
The vendor should specify to you (or you should ask the vendor to clarify to you) the type of database copy s/he wants:
1) "exp" exported dumpfiles of the subject schema (or its tables), or
2) a complete database image of all database files, which includes:
a) database data files (tablespace files)
b) on-line redo log files
c) control files,
...plus a helpful file that is not part of the database, your pfile parameter file named "init<SID>.ora".
If the vendor simply wants your application data, then they probably want just "1)". Option "2)" is a relative pain in some part of the body. But the vendor's specific interest will determine which flavour of database files s/he wants.
Let us know,
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
1) "exp" exported dumpfiles of the subject schema (or its tables), or
2) a complete database image of all database files, which includes:
a) database data files (tablespace files)
b) on-line redo log files
c) control files,
...plus a helpful file that is not part of the database, your pfile parameter file named "init<SID>.ora".
If the vendor simply wants your application data, then they probably want just "1)". Option "2)" is a relative pain in some part of the body. But the vendor's specific interest will determine which flavour of database files s/he wants.
Let us know,
Mufasa(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
- Status