Recent content by isonlyme

ok thank you very much for the help...

sorry but i dont see the import option in SQL 2000 enterprise manager, after following your suggestion...

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

well i let you know my results

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...

also, this table is partitioned if i extract a subset of data and imported back again will it be located in the correct partition?

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...

well after all your suggestions everything worked. the owner of the job on some cases was another user. thanks for the help!!