table storing in oracle 10g

5 pts.
Tags:
CREATE TABLE statement
Oracle
Oracle 10g
where does create table get stored in oracle 10g

Answer Wiki

Thanks. We'll let you know when a new response is added.

The default location is the system tablespace. This is bad because if the system tablespace gets full, the database fails. Create a new tablespace, and have a different user own any tables you create. You can alter the user to use the new tablespace as a default.

create tablespace data datafile ‘/directory/datafile.dbf’ size 100M autoextend on next 100M maxsize unlimited online permanent extent management local autoallocate segment space managment auto;

create user object_owner identified by object_owner_pwd;

alter user object_owner default tablespace data;

grant connect, resource to object_owner; — old school, but still works

– Good answer. I suggest setting a maxsize to something other than unlimited. Like 1000m or 2000m, etc.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Dwaltr
    I used a maxsize unlimited because I didn't know anything about the server configuration or the amount of data loaded. I would hate to have an load fail because of an arbitrary size limit on the tablespace.
    900 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following