| Data not getting inserted to specified tablespace [message #284151] |
Thu, 29 November 2007 01:02  |
pournami
Messages: 8
Registered: November 2007
|
Junior Member |
|
|
Hi,
I hav created a new tablespace and a new user.
Even though i hav assigned the new tablespace to the user, while importing , the data is taking system table space.
I am able to extend the system table space and watever path i give ther , its taking. But data is not getting inserted to the new tablespace with the same path of dbf file
How to resolve this issue??
regards
pournami
|
|
|
|
|
|
|
|
| Re: Data not getting inserted to specified tablespace [message #284189 is a reply to message #284162] |
Thu, 29 November 2007 02:32  |
pournami
Messages: 8
Registered: November 2007
|
Junior Member |
|
|
hi Arju,
Thanks for the reply..
as said i included Show = y in my imp command and cheked the ddl.. Found the table space as 'system' in the table scripts.
is it because of this , that even while importing ther r taking system tablespace. if so, in such cases how to change for the entire dump??
hi michael ,
thanks for the reply..
as said i revoked the umlimited table space from the user.cheked for quota but nothing has been asssigned.
But no impact has been seen while importing even though i changed.
Also , while creating the user we grant dba privilege. Because of this , the unlimited table space is getting selected in the system privilege option.. right?
if uncheked unlimited tablespace, then wat all privileges should i select if i want to giv the user all the privileges?
regards
pournami
|
|
|
|
|
|
|
|
|
|
| Re: Data not getting inserted to specified tablespace [message #284227 is a reply to message #284151] |
Thu, 29 November 2007 03:35 |
pournami
Messages: 8
Registered: November 2007
|
Junior Member |
|
|
Hi michael,
i revoked the DBA grant given..
but now i am not able to import.
i am getting a message as shown below
IMP-00058: ORACLE error 1045 encountered
ORA-01045: user TEST_P lacks CREATE SESSION privilege; logon deniedUsername:
Password:
for this i gave grant for 'create' dddl like create session, create table, etc.
then i got this error;
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully
wat to do now??
Hi arju,
I did as Michael said and above listed is the output.
Also, in ur reply u hav mentioned " extract ddl from dump (easily can be done by indexfile and remove rem from them) ".
I am not clear about it.. how to extract the ddl from dump?.. the dump might hav many tables. how to do for all??
hi mohammad,
i hav not grant resource role. only dba role role is present
regards
pournami
|
|
|
|
|
|
|
|
|
|
| Re: Data not getting inserted to specified tablespace [message #284282 is a reply to message #284151] |
Thu, 29 November 2007 05:27 |
pournami
Messages: 8
Registered: November 2007
|
Junior Member |
|
|
hi michael and Arju,
thanks a lot for the support given.
i did as u said.
first created the index file, removed rem , then corrected with correct tablespace.
the command given is
imp username/password@db file = x.dmp indexfile = i.dat show =y log = l.log
then after making changes i executed the indexfile after converting to sql file.
then gav command as
imp username/password@db file = x.dmp full = y show =y ignore = y log =l1.log
The data went to the specified tablespace now. But none of the procedures, functions and packages hav been imported..
Can u please tell me where i went wrong and tell me the correct command..
the grant given for user is still DBA.
regards
pournami
|
|
|
|
|
|
| Re: Data not getting inserted to specified tablespace [message #284316 is a reply to message #284151] |
Thu, 29 November 2007 06:30 |
pournami
Messages: 8
Registered: November 2007
|
Junior Member |
|
|
Michael,,,
in the log file ther is no errors reported..infact the procedures has been read but no error speciefied. also the import ended without warnings..
wat i realised is the import has not taken place now.
wat can be the reason??
the same import command has imported all the data earlier but to system tablespace..
the only change now i made in the import command was adding the ignore =y .
except for the tables created as a result of executing the index file, nothing has imported..
is my command missing anything??
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
