-
export and import
Assuming that I have taken a full database export of a database and I want to import it that to another database on the same machine. I know how to do that if I have to import it to the same database (recover) but not another database. Specifically, how do I do that? An example will be appreciated
I am running 8i on a UNIX platform
-
well if byou wanna import to another database using full option make sure the paths of datafiles that form the tablespaces are present
for example
original database: tablespace data is formed by data.dbf in /OTACLE/DBS
if you wanna import to another machine make sure /ORACLE/DBS exists.
If it's same machine you better go with user imports rather using full exports, you can still use the same export file though. This is because obviously you cant have 2 file with same name in same path in same machine.
-
OK, Pando. This is well understood. Now Assuming I have taken a full database export and I want to import user tables to another database on the same machine, How do I do that?
Can you please give me specific examples importing to another database on the same machine?
-
well instead of using full=y you use
userid=xxxxxx
file=xxxx
log=xxxx
fromuser=user=you_exported_from_another_db
touser=user_you_want_to_import
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|