| EXP/IMP - urgent please [message #156174] |
Mon, 23 January 2006 06:40  |
srhl
Messages: 24
Registered: December 2005
|
Junior Member |
|
|
i want to import the data to db2 (user2) from db1(user1) but while importing i am getting data in some tables which i don't want.
exp user2/user2 file=exp.dmp owner=user2 rows=n compress=y statistics=none grants=n log=exp.log
imp user1/user1 file=exp.dmp rows=n statistics=none grants=n ignore=y fromuser=user2 touser=user1
log= imptab.log constraints=n
Thanks in advance
|
|
|
|
| Re: EXP/IMP - urgent please [message #156176 is a reply to message #156174] |
Mon, 23 January 2006 06:43  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| srhl wrote on Mon, 23 January 2006 18:10 |
exp user2/user2 file=exp.dmp owner=user2 rows=n compress=y statistics=none grants=n log=exp.log
|
are you sure this is your export command because you are not exporting any rows.
And also read the manuals for export/import becuase it seems that you are not comfortable with the exact purpose of the parameters.
[Updated on: Mon, 23 January 2006 06:46] Report message to a moderator |
|
|
|
|
|
|
|
| Re: EXP/IMP - urgent please [message #156195 is a reply to message #156194] |
Mon, 23 January 2006 08:29 |
srhl
Messages: 24
Registered: December 2005
|
Junior Member |
|
|
i created a new schema in database db1 as follows:
CREATE USER user1
IDENTIFIED BY user1
DEFAULT TABLESPACE tb1
TEMPORARY TABLESPACE TEMP;
and granted the following privs:
GRANT create session TO user1;
grant connect to user1;
grant RESOURCE, EXP_FULL_DATABASE, IMP_FULL_DATABASE to user1;
exp/imp
--------
I exported from database db2 using the following:
exp user2/user2 file=exp.dmp owner=user2 rows=n compress=n statistics=none grants=n log=exp.log
imp user1/user1 file=exp.dmp rows=n statistics=none grants=n ignore=y fromuser=user2 touser=user1
log= imptab.log constraints=n
Some of the tables contains data and because the data is consuming space i got the following error also:
IMP-00003: ORACLE error 1659 encountered
ORA-01659: unable to allocate MINEXTENTS beyond 7 in tablespace tb1
Questions:
Why the data also gets imported with rows=n?
Its a new schema.
oracle version: Oracle9i Enterprise Edition Release 9.2.0.3.0
|
|
|
|
| Re: EXP/IMP - urgent please [message #156196 is a reply to message #156195] |
Mon, 23 January 2006 08:37 |
srhl
Messages: 24
Registered: December 2005
|
Junior Member |
|
|
|
for importing the table struture and their associated objects from one user to other user on different databases, what are all the parameter do i need to specify in exp and imp command (without any data)?
|
|
|
|
| Re: EXP/IMP - urgent please [message #156198 is a reply to message #156196] |
Mon, 23 January 2006 08:53 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
either your target tablespace tb1 is full
or
Your source table DDL has to be changed.
Try with smaller values of minextent / next etc.
And what is your OS?
If it is windows, if the datafile is 4b with autoextend ON, there are known bugs here.
[Updated on: Mon, 23 January 2006 09:35] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
