Home » Other » Training & Certification » Space check
Space check [message #268103] Mon, 17 September 2007 09:17 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


hi guys,

can anybody tell me why do we check space on default tablespace while doing logical backup (import/export).

another is why do we specify default tablespace during user creation.

Cheers
Balaji
Re: Space check [message #268186 is a reply to message #268103] Mon, 17 September 2007 22:24 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
balaji1482 wrote on Mon, 17 September 2007 09:17

another is why do we specify default tablespace during user creation.



If you do not specify default tablespace then its assign to system tablespace. And it is suggested that specify specific tablespace for each schema. That why we specific default tablespace during user creation.
Re: Space check [message #268194 is a reply to message #268103] Mon, 17 September 2007 23:13 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
another is why do we specify default tablespace during user creation.
If you do not specify default tablespace then its assign to system tablespace.


This is not true. It's depend on database creation script. When you use DBCA default tablespace is users.

[Updated on: Mon, 17 September 2007 23:27]

Report message to a moderator

Re: Space check [message #268196 is a reply to message #268103] Mon, 17 September 2007 23:23 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
why do we check space on default tablespace while doing logical backup

We should check space because data will imported into default tablespace if you don't specify.

If default tablespace is not assigned data goes to system tablespace.

[Updated on: Mon, 17 September 2007 23:29]

Report message to a moderator

Previous Topic: Looking for discount for 9i funda training
Next Topic: need sql query
Goto Forum:
  


Current Time: Fri Mar 29 05:16:41 CDT 2024