| shipon |
Posted: May 14, 2008 02:48:00 AM |
Total Post: 46
Joined: Feb, 2008
|
Dear Friends ,
I have two database in windows and linux RHEL5 platform .
databases are:
1) TESTDB : in windows platform
2) ORCL : in Linux platform
Now I have the following questions :
1) I want to copy a database from windows to linux or vice-versa . Firstly when I take full export from TESTDB then which informations of the database exported , here i use FULL=Y ?
and if I import this "testdb export dump" to "linux ORCL Database" then is it work ?
2) If I want to copy all datafile, control file and redolog files from windows(TESTDB) to Linux (ORCL) , then is it work properly ? Here I want to copy full database from windows to linux ?
3) Can anyone plz tell me simply , "what is metadata" and "Data Definition" ?
Waiting for ur kind reply .. ... |
|
|
 GOPU |
| Posted: May 14, 2008 03:15:20 AM |  |
|
Total Post: 350
Joined: Apr, 2008
|
first of all dont post the same question more than one..K
1.you can take an export from a database which is located in the windows machine and you can import it in to the linux machine.It will work.
2.you can clone a database from windows platform to linux platform.
|
|
|
|
|
| Gitesh |
| Posted: May 14, 2008 04:34:53 AM | |
|
Total Post: 322
Joined: May, 2005
|
Export is the logical backup. It is not dependent on operating system. We can take export of database on any platform and import on any platform.In your case you can take export from linux and import in windows or reverse.
Only export dump (.dmp default extention) you should need to copy to target platform. There is no need to copy all datafiles.
There is another feature called transportable tablespace in export. But it is operating system dependent.
Metadata is the database internal system data dictionary structure and user schema structure.
|
|
|
|
|
| GOPU |
| Posted: May 14, 2008 04:38:02 AM | |
|
Total Post: 350
Joined: Apr, 2008
|
About METADATA
The word meta comes from the Greek, where it means 'after' or 'beyond'. In epistemology, the prefix meta- is used to mean about (its own category); thus metadata is 'data about the data'.
Metadata (sometimes written 'meta data') are used to facilitate the understanding, characteristics, and management usage of data. The metadata required for effective data management varies with the type of data and context of use. In a library, where the data is the content of the titles stocked, metadata about a title would typically include a description of the content, the author, the publication date and the physical location.
In the context of an information system, where the data is the content of the computer files, metadata about an individual data item would typically include the name of the field and its length. Metadata about a collection of data items, a computer file, might typically include the name of the file, the type of file and the name of the data administrator.
|
|
|
|
|
| GOPU |
| Posted: May 14, 2008 04:41:58 AM | |
|
Total Post: 350
Joined: Apr, 2008
|
for data definitions
http://oldweb.uwp.edu/academic/mis/Baldwin/oraddl.htm
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: May 14, 2008 05:11:52 AM | |
|
Total Post: 135
Joined: Apr, 2008
|
alternatively you can use clone database ... to see how please go through
http://sharear.blogspot.com/search/label/Oracle%20Database%20Cloning
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
