Home » RDBMS Server » Server Utilities » How to backup? (Oracle Server)
How to backup? [message #556167] Thu, 31 May 2012 12:19 Go to next message
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!
Re: How to backup? [message #556169 is a reply to message #556167] Thu, 31 May 2012 12:21 Go to previous messageGo to next message
BlackSwan
Messages: 26757
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=
Re: How to backup? [message #556170 is a reply to message #556169] Thu, 31 May 2012 12:26 Go to previous messageGo to next message
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?
Re: How to backup? [message #556172 is a reply to message #556170] Thu, 31 May 2012 12:41 Go to previous messageGo to next message
Michel Cadot
Messages: 67649
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read the link BlackSwan provided?

Regards
Michel
Re: How to backup? [message #556173 is a reply to message #556167] Thu, 31 May 2012 12:44 Go to previous messageGo to next message
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:*********

Re: How to backup? [message #556174 is a reply to message #556173] Thu, 31 May 2012 12:47 Go to previous messageGo to next message
thorax
Messages: 3
Registered: May 2012
Location: Florida
Junior Member
Thank You! you solved problem. Now
Re: How to backup? [message #556175 is a reply to message #556173] Thu, 31 May 2012 12:47 Go to previous messageGo to next message
Michel Cadot
Messages: 67649
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
Re: How to backup? [message #556182 is a reply to message #556175] Thu, 31 May 2012 14:12 Go to previous messageGo to next message
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
Re: How to backup? [message #556185 is a reply to message #556182] Thu, 31 May 2012 14:53 Go to previous messageGo to next message
BlackSwan
Messages: 26757
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.
Re: How to backup? [message #556225 is a reply to message #556185] Fri, 01 June 2012 00:55 Go to previous message
Michel Cadot
Messages: 67649
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:
  


Current Time: Sat Jan 23 12:22:15 CST 2021