Hi all,
I have 100 server group by location:
State1
servername1
servername2
State2
servername1
I need to move all those groups and server registration to another pc. I exported the list but how do I imported on the other pc?
I found 1 solution involving exporting the REGISTERED SERVER X...
wow thanks perfect,
Aditionally is there a way to view the access that a role have?
I mean for example:
Rolename: RoleSelectOnly
Has:
Select on TABLENAME1
Select on TABLENAME2
etc.
Im a rookie at this sorry and thanks in advanced
Hi everyone,
Is there a way to create a script that can give you the following?
username,
what database is using,
what role it has,
what access have
thanks in advanced
thats what i was trying to avoid... thas why i wanted the prompt so for each loop it will ask me for the new value
nontheless thank you very much for your comments
thanks guy,
The script is for me to run not the user, I dont want to hard code a lot of parameters every time i ran it thats why i wanted a prompt on the analyzer for me to use
so first run i input "jjj"
next run i input "aaaa" and so on.
is there a way without using SP, or aditional...
hi,
Im trying to do a simple thing, waiting for a user to input
a value so i can pass it to a sql statement and do a select according to their input like:
Declare @USERINPUT varchar(50)
Select * from MYTABLE where MYFIELD = @USERINPUT
But the trick is I can't use it on a store procedure...
well my plan worked the import with 8/31 was inserted inteir correct partitions and I also used the insert into solution for data that was in other tables.
thanks guys
Thank you santamufasa, I tought of doing that but
This is a datawarehouse, where we don't backup using the export utility and then passing it on to tape.
this is done every once a week:
1- We shutdown the database
2- Backup the physical files of the database
3- startup the database
now my...
thank you for the response,
Im trying to backup just the End of month data of 8/31 instead of the whole table and then imported to oracle again. I lost some data and i need to do a restore that is old and doesnt have the 8/31 data, so i wanted to export out the data i need so after restoring...
Hi,
I'm trying to export a subset of data using a date field
using this:
exp user/pass file=flename.dmp log=filename.log tables=MY_TABLE query=\"where as_of_dt='08-31-2007'\"
and this is the error it gave me:
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes
Export...
thanks for yuor inputs,
i'll check on this and let you know the results. So far the user on both enviorments have the same security level...
let you know more during the day.
HI,
I have a Database Called PRODDB the owner is USER1 and a table called MYTABLE that was created by USER1 and also USER1 is owner of the table.
I have setup the exact same database and user in TEST enviorment.
In test a DTS that reads a file and upload it in a table and do a simple select...
Hi guys,
i want to do transaction log backup for an audit but my software conflicts with the directory of the transaction log in prod so I want to schedule another backup after 30 minutes from the original transaction backup in prod to capture the data from my new directory.
Qustion if i have...
Hi ,
I'm looking for a way to deny users from droping tables
in the BOL i cant find a revoke statement
if i write this:
revoke drop table to test
i get thios error
privilige DROP <object> may not ber granted or revoke
is there a way to to do this?
thanks in advanced
ok, the data that should be there are telephone numbers
(123)123-3454 etc... and extentions 3434 etc..
the problem was tha the extensions when converted they look like this
3434.0
so i need to get rid of only the records that have .0 so i came up with this from all your suggetsions
update...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.