Alter table space size.

[targinosilveira]

Good afternoon guys, I have the following problem, I got a system in Oracle Forms for maintenance and did a dump via exp, when I went to run the IMP to retrieve the data on my work machine, I received the following error:

IMP-00003: Oracle Error: 1658 Found
ORA-01658: Normable to create the initial extension for the segment in the space of
System work

I took a look at the web interface, and it shows me that the tablespace is like autoextend, I do not know very well what is happening.

I am very grateful with any help.

Sincerely,

Environment information:
* Oracle XE 10g
Windows XP

[diegopedrao]

Select all

 
 
SELECT * 
  FROM DBA_DATA_FILES 
 WHERE TABLESPACE_NAME = 'SYSTEM'; 

Checks if the 'AutoExtensible' field is 'yes' but do the following:

Add a new date File or try to give a Resize in System DataFile.

Select all

 
 
alter tablespace TABLESPACE_NAME add datafile 'C:\CAMINHO\NOME_DO_DATAFILE.DMP' SIZE 2048M; 

or Senao:

Select all

 
alter database datafile 'C:\CAMINHO\NOME_DO_DATAFILE.DMP' resize 2048M; 

ATT,

Diego Monteiro [/ Code]

[diegolenhardt]

When you are going to create a table you can allocate the entire size of the table with the initial parameter, that is, your initial is being higher than the space available on the tablespace, so Oracle can not create your table,



ALTER TABLESPACE YOUR_TABLESPACE
Add DataFile 'C: \ xx \ SUATABLESPACE.DBF' Size 4M AUTOEXTEND OFF;

or do resize in Datafile by increasing your tablespace,

could use the IPDB (DataPump) and make a remap of tablespaces, as you create tables on Tablespace System is not recommended.

falows

[targinosilveira]

Is the following all tablespaces are with autoextend = yes and how can I do so that this import goes to another tablespace other than the system?

Sincerely

[diegolenhardt]

See EXPDP and IPDP, utility called Oracle Datapump,

Read the article: http://www.oracle-base.com/articles/10g ... ump10g.php
Watch out for the remap, used when importing,




can try to create another user and import the dump, I think it goes to tablespace default, in the case it is going to system because you should be importing pro schema sys / System,

Creates another user and arrow to default tablespace for Users,

This import was generated from another bank that in case it is not XE?

If yes, what is the size of the export?

[targinosilveira]

It was generated from another XE bank, and has a size of 504MB.


Sincerely,

[diegolenhardt]

I thought it could be restricted to the XE limit, (4GB maximum size),

Finally, if you want to migrate the tablespaces, it will have to be by the DataPump, as said, or first create the tables in the Hand on the bench, if you have the XE base online that you have exported, with the datapump you can make import / export via direct network.

[targinosilveira]

Ok, I made an EXPDB here but he saved the file on the server, I did the EXPDP through my machine, how can I set the Oracle to create the directory on my machine and save the .dmp file on my machine and not on the server.

Why can not I copy the server here for my machine.

I think it works out there it would be only, do the IMPDP for the new Schema created, correct?

Sincerely,

[diegolenhardt]

Exactly, it would be to do the import with the remap_tablespace parameter, I think you can not point to your machine, what difficulty in copying the file to your machine?

Do not have access? password? etc.

has a package that makes file transfer, but then I think it complicates things too much, rs

could try to do with the datapump using the option to make migration with dblink, which would be direct server - server, no need to export, copy the file to the destination machine, import,

parameter:
Network_link name of Remote Database Link to the Source System.

I can not tell you if the XE will have this feature ...

makes a resize on your Tablespace System man, putting her with a 2 giga, It does the import, and then makes a move from the tables,

Select all

alter table TABELA move tablespace YYY;

after this is necessary to rebild the indications,

Select all

ALTER INDEX INDEX_NAME REBUILD;

]
easier by consulting

Select all

user_indexes where status = 'UNUSABLE';

That way you move the table to another tablespace after imported, I think it's the simplest solution ...

[elidias7]

Oops, beauty?

A doubt, you exporting the entry bank, specific users or only tables?

I think that for you to do the Export for your machine you will have to use the EXP and EXPDP utility, as EXPDP will generate the Export to a directory specified in the database. EXP You can generate for any client.

The problem you will have is to create all the tablespace and users that exist in the bank from which you are exporting the data in the bank that will receive the data if they are not the same.

Hugs,

[targinosilveira]

Opa, man the business is the following, I am exporting only a schema, I did the IMPDP, I created a directory to put the file generated by the EXPDP, I gave the rights and all all, when I run the IMPDP it begins to import, but it gives me A bunch of errors (many same errors): D of type ORA-39112.

As for EXP was what I always used in one time I had to work with Oracle and always funfou cool, I'vê been seeing that in Schema that I'm exporting there are many users, I think it should be it Even though it is generating the problem.

any more light? : D

Sincerely,

[diegolenhardt]

A schema = User = Owner ... etc

An instance may have several schemas (Users),

If you do via Exp / IM Create all users before the import process,

[targinosilveira]

That's what I'm starting to do.
Hugs ....

[diegolenhardt]

It is very much more annoying, including must create the tablespaces as well, otherwise it will have error in the creation of the tables, already with the datapump is not necessary, because it would make the remap,

any doubt we are there

Good luck,

[targinosilveira]

beleza Dude, is now giving stick because of the roles, is there any way to export the user with the roles? Because I created all and ta giving this dick ...

vlw

[diegolenhardt]

Two options, you can try to export or import without grants,

that would be putting the Grants = N, or still trying to import with the parameter ignore = Y,

see what happens,

ah, take a look at: exped help = y

Select all

imp HELP=Y,

give you a list of all Parameters and possible values,

=]

[targinosilveira]

Okay, Diego, I got to import there with various warnings, I'll see the options in the imp ....

Thank you for the help ...