I don't think select will lock anything. An export selects. But other DML will create locks, and you need to be able to obtain a lock on the whole table before the DDL will succeed.
-----Original Message-----
From: Ganhão, Luís Manuel Martins, VF-PT [mailto:oracledba-ezmlmshield-x64492202.[Email address protected]
Sent: Thursday, May 05, 2005 10:42 AM
To: LazyDBA Discussion
Subject: RE: Alter table script hanging
Someone or some process it's using the table (can be a simply select)
When you run a SELECT the object it's locked for any changes
Regards,
LG
-----Original Message-----
From: nagarajanv
[mailto:oracledba-ezmlmshield-x14249827.[Email Address Removed] zyDBA.com]
Sent: quinta-feira, 5 de Maio de 2005 15:36
To: LazyDBA Discussion
Subject: FW: Alter table script hanging
Hi,
When we run the alter table script for adding
a column in the sql prompt, it is not running and
hanging.What could be reason? and how to reolve it?
Could you please help me??.
Thanks & Regards
Nagarajan.V
-----Original Message-----
From: nagarajanv
[mailto:oracledba-ezmlmshield-x96942910.[Email
address protected]
Sent: Thursday, May 05, 2005 7:57 PM
To: LazyDBA Discussion
Subject: Alter table script hanging
Hi,
When we run the alter table script for adding
a column in the sql prompt, it is not running and hanging.
Could you please help me??.
Thanks & Regards
Nagarajan.V
DISCLAIMER:
Information transmitted by this e-mail may be
proprietary to Ramco Systems Ltd., and / or the
authors of the information and is intended for use
only by the individual or entity to which it is
addressed, and may contain confidential or legally
privileged information. If you are not the intended
recipient or it appears that this mail has been
forwarded to you without proper authority, you are
not authorised to access, read, disclose, copy, use
or otherwise deal with it and any such actions are
prohibited and may be unlawful.
Internet communications cannot be guaranteed to be
secure or error-free as information could be
intercepted, corrupted, lost, arrive late or contain
viruses. Ramco Systems Limited therefore does not
accept liability for any errors, omissions, viruses
or computer problems experienced as a result of this
transmission.
If you have received this e-mail in error, please
notify us immediately at mail to: [Email address
protected] and delete this mail from your records.
Notice is hereby given that no representation,
contract or other binding obligation shall be created
by this e-mail.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
DISCLAIMER:
Information transmitted by this e-mail may be
proprietary to Ramco Systems Ltd., and / or the
authors of the information and is intended for use
only by the individual or entity to which it is
addressed, and may contain confidential or legally
privileged information. If you are not the intended
recipient or it appears that this mail has been
forwarded to you without proper authority, you are
not authorised to access, read, disclose, copy, use
or otherwise deal with it and any such actions are
prohibited and may be unlawful.
Internet communications cannot be guaranteed to be
secure or error-free as information could be
intercepted, corrupted, lost, arrive late or contain
viruses. Ramco Systems Limited therefore does not
accept liability for any errors, omissions, viruses
or computer problems experienced as a result of this
transmission.
If you have received this e-mail in error, please
notify us immediately at mail to: [Email address
protected] and delete this mail from your records.
Notice is hereby given that no representation,
contract or other binding obligation shall be created
by this e-mail.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page