|
|
| Re: Format of Export & Import Commands [message #373445 is a reply to message #373413] |
Tue, 17 April 2001 14:03  |
Cindy
Messages: 88
Registered: November 1999
|
Member |
|
|
Hi,
What do you meant by format of export/import? If you mean how do you export/import data, then this may be helpful.
There are many export and import options, thus the method/methods to export and import depend on what you want to accomplish:
EXAMPLES:
By tables:
exp login/password full=n rows=y compress=y file=file_name.dmp log=log_name.log tables=table1, table2, table3
imp login/password full=n rows=y ignore=y file=/file_name.dmp log=log_name tables=table1, table2, table3
By user:
exp login/password file=file_name.dmp owner=user_name.log full=n grants=y rows=y compress=y log=log_name.log
imp login/password full=n rows=y ignore=y file=/file_name.dmp log=log_name.log owner=user_name
Full database backup (filesize < 2G):
exp login/password full=y direct=y INCTYPE=complete file=file_name.dmp log=log_name.log
imp login/password full=y ignore=y inctype=restore file=file_name.dmp log=log_name.log
Full database backup (filesize > 2G):
exp login/password full=y direct=y INCTYPE=complete file=file_name1.dmp,file_name2.dmp filesize=2047M log=log_name
imp login/password full=y direct=y INCTYPE=restore file=file_name1.dmp, file_name2.dmp filesize=2047M ignore=y log=log_name.log
For more information on export/import:
http://www.cs.montana.edu/~admin/oradoc/server.815/a67792/toc.htm
Use 'ignore=y' option on any import when tables exist in database.
Hope this help.
--Cindy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
