OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » How to backup? (Oracle Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to backup? [message #556167]

Thu, 31 May 2012 12:19

thorax
Messages: 3
Registered: May 2012
Location: Florida

Junior Member

How to backup teh tables in a schema? I need som halp on this subjekt. I hav Dev envrnment that I must to backup.

Thanks advance!

Report message to a moderator

Re: How to backup? [message #556169 is a reply to message #556167]

Thu, 31 May 2012 12:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

http://www.oracle.com/pls/db112/search?word=expdp&partno=

Report message to a moderator

Re: How to backup? [message #556170 is a reply to message #556169]

Thu, 31 May 2012 12:26

thorax
Messages: 3
Registered: May 2012
Location: Florida

Junior Member

Please i hav surched goggle and teh forum. But how to backup specific table only?

Report message to a moderator

Re: How to backup? [message #556172 is a reply to message #556170]

Thu, 31 May 2012 12:41

Michel Cadot
Messages: 68352
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Did you read the link BlackSwan provided?

Regards
Michel

Report message to a moderator

Re: How to backup? [message #556173 is a reply to message #556167]

Thu, 31 May 2012 12:44

vijenderkdba
Messages: 28
Registered: May 2012
Location: mumbai

Junior Member

hi

you need to take the logical backup of tables in the schema.

go to cmd prompt
)exp file=<filename.dmp> log=<filename.log> tables=<schema>.<table_name>
then it will ask the username and password
give username:sys as sysdba(if multiple databases in the single server then sys@<alias_nmae of tns> as sysdba)
pasword:*********

Report message to a moderator

Re: How to backup? [message #556174 is a reply to message #556173]

Thu, 31 May 2012 12:47

thorax
Messages: 3
Registered: May 2012
Location: Florida

Junior Member

Thank You! you solved problem. Now

Report message to a moderator

Re: How to backup? [message #556175 is a reply to message #556173]

Thu, 31 May 2012 12:47

Michel Cadot
Messages: 68352
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

give username:sys as sysdba

NO!

- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer)
- SYS/SYSDBA does not act like any other user
- When you use SYS/SYSDBA Oracle deactivates some code path and activates others
- Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user.

NEVER EVER use SYS/SYSDBA for anything that can be done by another user.
Use SYS/SYSDBA ONLY for something that can't be done by someone else.

Regards
Michel

Report message to a moderator

Re: How to backup? [message #556182 is a reply to message #556175]

Thu, 31 May 2012 14:12

vijenderkdba
Messages: 28
Registered: May 2012
Location: mumbai

Junior Member

generally these things did by the dba's....so thats why im given as sys as username.

any way notmal user is not able to exported wihtout permissions.

Thanks,
Vij

Report message to a moderator

Re: How to backup? [message #556185 is a reply to message #556182]

Thu, 31 May 2012 14:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>generally these things did by the dba's....so thats why im given as sys as username.
NOBODY should be using SYS including the DBAs.

Report message to a moderator

Re: How to backup? [message #556225 is a reply to message #556185]

Fri, 01 June 2012 00:55

Michel Cadot
Messages: 68352
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And, in addition, this does not change a single word of what I posted.

Regards
Michel

[Updated on: Fri, 01 June 2012 01:03]

Report message to a moderator

Previous Topic:	Importing table from 9i to 10g
Next Topic:	IMPDP (ORA-31619: Invalid dump file)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 08 23:36:43 CST 2023